J
Jon
I'm trying to use VLOOKUP to find values on sheet1, looking up values from
sheet2, so basically:
A2 to Axx: =VLOOKUP(D2,Sheet2!A1:B154938,1,FALSE)
B2 to Bxx: =IF(A2=C2,"Found","") - Display "Found" if vlookup (column A) is
successful; blank if none
C2 - the value i want to look up e.g. 000018901
The problem is that since when the values are not found VLOOKUP returns
'#N/A', the values are returned as:
'Not found' when the IF statemetn (B2) is true; whilst it should be 'Found'
'#N/A' for other values.
Is this a bug?
sheet2, so basically:
A2 to Axx: =VLOOKUP(D2,Sheet2!A1:B154938,1,FALSE)
B2 to Bxx: =IF(A2=C2,"Found","") - Display "Found" if vlookup (column A) is
successful; blank if none
C2 - the value i want to look up e.g. 000018901
The problem is that since when the values are not found VLOOKUP returns
'#N/A', the values are returned as:
'Not found' when the IF statemetn (B2) is true; whilst it should be 'Found'
'#N/A' for other values.
Is this a bug?