| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
whats wrong with the formula?
=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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
whats wrong with the formula?
Hi, I guess u r missing to use $ in the vlookup! try below: =IF(ISNA(VLOOKUP(A3,Sheet2!$A$1:$B$12,2,FALSE)),"N o Results Found",(VLOOKUP(A3,Sheet2!$A$1:$B$12,2,FALSE))) Thanks, Tarek -- Tarek ------------------------------------------------------------------------ Tarek's Profile: http://www.excelforum.com/member.php...fo&userid=6325 View this thread: http://www.excelforum.com/showthread...hreadid=567764 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
whats wrong with the formula?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's wrong with this formula? | Excel Discussion (Misc queries) | |||
| excel formula calculations are wrong | Excel Worksheet Functions | |||
| Formula retrieves wrong data | Excel Discussion (Misc queries) | |||
| Recalculating Formula - Getting the wrong answers | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Hybrid Mode
