| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using a vlookup, can i use isblank to show an empty cell
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using a vlookup, can i use isblank to show an empty cell
Sandy
=IF(B2="","",VLOOKUP(B2,....) Regards Trevor "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 |
|
#3
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using a vlookup, can i use isblank to show an empty cell
Hi!
A1 = lookup value (reference cell) Try this: =IF(A1="","",your_vlookup_formula_here)) Biff "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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using a vlookup, can i use isblank to show an empty cell
Hi Trevor,
Thanks very much for the solution, it worked a treat Thanks Again Sandy "Trevor Shuttleworth" wrote: Sandy =IF(B2="","",VLOOKUP(B2,....) Regards Trevor "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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using a vlookup, can i use isblank to show an empty cell
You're welcome. Thanks for the feedback
"Sandy" wrote in message ... Hi Trevor, Thanks very much for the solution, it worked a treat Thanks Again Sandy "Trevor Shuttleworth" wrote: Sandy =IF(B2="","",VLOOKUP(B2,....) Regards Trevor "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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using a vlookup, can i use isblank to show an empty cell
I have a similar situation but get NA when there is not match.... have a
solution? "Biff" wrote: Hi! A1 = lookup value (reference cell) Try this: =IF(A1="","",your_vlookup_formula_here)) Biff "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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using a vlookup, can i use isblank to show an empty cell
See your other post.
-- Biff Microsoft Excel MVP "jane" wrote in message ... I have a similar situation but get NA when there is not match.... have a solution? "Biff" wrote: Hi! A1 = lookup value (reference cell) Try this: =IF(A1="","",your_vlookup_formula_here)) Biff "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 |
| Reply |
| 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 | |||
Linear Mode
