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
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