| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Empty cell in vlookup
hi, is there a way to have a vlookup see an empty cell and rather than
filling it in with a 0 it could leave it blank? here's my vlookup formula =IF(A21="","",VLOOKUP(A21,'PN Source Code'!$A$1:$H$25,8,FALSE)) Thank you in advance for your help :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup ignoring empty cells | Excel Worksheet Functions | |||
| using a vlookup, can i use isblank to show an empty cell | Excel Worksheet Functions | |||
| empty cells in a vlookup list | Excel Worksheet Functions | |||
| Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
Threaded Mode
