VLookup & hiding error #NA

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

Hello ... still learning Excel and have a
formatting/function problem. Worksheet A uses VLookup to
post values from a list on Worksheet B. WorksheetA is
formatted for 200 rows of information, however if the
lookup value cell doesn't have anything posted in it, then
it dispays "#N/A" in the target cell and I would like to
eliminate the #N/A from displaying. The VLookup is simple,
just don't know how to write a nested formula or add
something to remove #N/A. The current formula is as
follows:

=VLOOKUP(B25,Option_Index.xls!Option_range,2,FALSE)&" "&
(G25)

Any help/advice appreciated. Thanks in advance.

Patrick
 
Patrick said:
Hello ... still learning Excel and have a
formatting/function problem. Worksheet A uses VLookup to
post values from a list on Worksheet B. WorksheetA is
formatted for 200 rows of information, however if the
lookup value cell doesn't have anything posted in it, then
it dispays "#N/A" in the target cell and I would like to
eliminate the #N/A from displaying. The VLookup is simple,
just don't know how to write a nested formula or add
something to remove #N/A. The current formula is as
follows:

=VLOOKUP(B25,Option_Index.xls!Option_range,2,FALSE)&" "&
(G25)
Click to expand...

Modify this formula to work for you:
=IF(ISBLANK(A1),"","PASTE YOUR VLOOKUP FORMULA HERE")
Where cell A1 is referenced, change that to the cell you want to be tested
for an entry, if no entry is found, nothing is done.
 
M. Lane ...

thanks for the formula ... couldn't get it to work at
first, added another ) past the false and worked like a
charm. Thanks so much ... worksheet is now #N/A fee ...
thanks again

Patrick
 
here's a hint
=if(isna(VLOOKUP(B25,Option_Index.xls!
Option_range,2,FALSE)&" "& >(G25),"",(VLOOKUP
(B25,Option_Index.xls!Option_range,2,FALSE)&" "&
(G25))
 
Here's another hint... it's best to leave the original subject line
in your reply (with Re: prepended) - helps people find your answer
more readily. Almost all replies *could* be titled "here's a hint"
(the rest being "I haven't a clue"), but they don't provide much
information.
 
Back
Top