Vlookup Returning #n/a
Thank you all very helpful
"Pete_UK" wrote:
The usual way of doing this is:
=IF(ISNA(your_vlookup),"",your_vlookup)
or you might have a zero instead of "", or some other message like
"not present".
Hope this helps.
Pete
On Jul 4, 11:52 pm, Toolbar Confused
wrote:
I have a large workbook that I am using vlookup in. It is returning #n/a wher
e there is no data to pull. I am trying to add another formula to pull a
range of numbers from the main sheet. It works fine as long as there are no
NA's in the data I am pulling from. I need to know how to change the formula
to not return the N/A but not ruin the formula if the data is there to be
pulled.
Thanks in advance for any help
|