| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using a vlookup, can i use isblank to show an empty cell
Hi Sandy,
Try this format with ranges to suit your sheet. =IF(ISNA(VLOOKUP(B2,$H$4:$I$18,2,FALSE)),"",VLOOKU P(B2,$H$4:$I$18,2,FALSE)) HTH Regards, Howard "Sandy" wrote in message ... I am trying to create an excel solution using a vlook up, but in the formula cell i would like to cell to be blank if nothing has been entered in the reference cell Thanks Sandy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP using a cell calculated with NOW returns Error | Excel Worksheet Functions | |||
| Using a cell reference of a sheet in Vlookup | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Function making cell really "empty" | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
