=IF(ISNA(VLOOKUP(A3,Sheet2!A1:B12,2,FALSE)),"No Results
Found",(VLOOKUP(A3,Sheet2!A1:B12,2,FALSE)))
Always returning "No Results Found".
Please help
=IF(ISNA(VLOOKUP(A3,Sheet2!A1:B12,2,FALSE)),"No Results
Found",(VLOOKUP(A3,Sheet2!A1:B12,2,FALSE)))
Always returning "No Results Found".
Please help
Hi,
I guess u r missing to use $ in the vlookup! try below:
=IF(ISNA(VLOOKUP(A3,Sheet2!$A$1:$B$12,2,FALSE)),"No Results
Found",(VLOOKUP(A3,Sheet2!$A$1:$B$12,2,FALSE)))
Thanks,
Tarek
You are looking for an exact match. Check the values in Sheet2 column A
to see that you have no spurious spaces at the beginning or end. Ensure
that the value in A3 has no extra spaces.
Hope this helps.
Pete
Gary wrote:
> =IF(ISNA(VLOOKUP(A3,Sheet2!A1:B12,2,FALSE)),"No Results
> Found",(VLOOKUP(A3,Sheet2!A1:B12,2,FALSE)))
>
> Always returning "No Results Found".
>
> Please help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks