VLOOKUP returns #N/A
The Data sheet contains a column with numeric values. The lookup table deliberately does not contain all of the values found in the Data sheet. When the formula
=VLOOKUP(I6,Fire,2,FALSE) is applied the result is #N/A when the value in I6 is not found in "Fire" lookup. Is there a way to have the result display as a blank cell instead of #N/A when this condition occurrs. Thanks in anticipation. |
VLOOKUP returns #N/A
One way:
=if(isna(VLOOKUP(I6,Fire,2,FALSE)),"",VLOOKUP(I6,F ire,2,FALSE)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "shannon c" wrote in message ... The Data sheet contains a column with numeric values. The lookup table deliberately does not contain all of the values found in the Data sheet. When the formula =VLOOKUP(I6,Fire,2,FALSE) is applied the result is #N/A when the value in I6 is not found in "Fire" lookup. Is there a way to have the result display as a blank cell instead of #N/A when this condition occurrs. Thanks in anticipation. -- shannon c |
Works like a charm - thanks Max.
I was playing around with the "ISNA" solution but couldn't quite get the sequence right. |
VLOOKUP returns #N/A
|
All times are GMT +1. The time now is 09:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com