vlookup useful?

  • Thread starter Thread starter Timo
  • Start date Start date
T

Timo

Dear all,

I thought I could use vlookup and combine it with an if function. However I
don't know how to do it.

example sheet:

ID name shs test results ID name shs

1234 Timo 13 D2 1225 Timo 20
1225 Timo 20 D3 1234 Timo 10


I thought vlookup can help if (A2+B2) match (E2+F2), then return the value
in column G.

Result: Cell D2 should show value "10" (G3) and Cell D3 should show value
"20" (G2).

Thank you all in advance.

Regards, Timo
 
Hi NBVC,

now it worked fine! Thanks. Thought I could quickly try, but A2 was not
within the first 100 rows. Now I changed it to 4000...

Thanks a million.

Timo
 
Back
Top