| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup
I am trying to do a vlook up on a table of data. The table of data is based
on another formula so the value that is being searched for is formula based which is returning a #N/A value, can i get around this?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLookup
"April" skrev i en meddelelse
... I am trying to do a vlook up on a table of data. The table of data is based on another formula so the value that is being searched for is formula based which is returning a #N/A value, can i get around this?? April One way, if I have understood you correctly: =IF(ISERROR(your lookup formula), "Does not exist", your lookup formula) -- Best regards Leo Heuser Followup to newsgroup only please. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup a Vlookup | Excel Worksheet Functions | |||
| VLOOKUP Problem | Excel Discussion (Misc queries) | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Linear Mode
