Using Vlookuop and then calculating
Give this a try in Colum J
=IF(ISERROR(OR(VLOOKUP(I1,$A$1:$B$5,2,0),VLOOKUP(I 1,$D$1:$E$5,2,0))),"Entry
not found",VLOOKUP(I1,$A$1:$B$5,2,0)-VLOOKUP(I1,$D$1:$E$5,2,0))
--
Thanks for your help -
Joe Mac
"Jaco Jacobs" wrote:
I have a sheet that has various different values and I would like to check
for the same number then take one figure from another.
A has value 3000001 and so has D and I but in different rows
In columns B and E there are values that would need to be taken from each
other but only if D and A match with I.
The calculation needs to be in J
Hope this makes sense
|