Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need Vlookup to return a blank
I need Vlookup to return a blank if the appropriate cell is empty.
Thank you so much . . . .Y'all have been extremely helpful!! J. |
#2
|
|||
|
|||
This will work -
=if(vlookup(,,,)=[whatever the cause of the blank is],"",vlookup(,,,)) "Eaglered" wrote: I need Vlookup to return a blank if the appropriate cell is empty. Thank you so much . . . .Y'all have been extremely helpful!! J. |
#3
|
|||
|
|||
Try something like
=IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Eaglered" wrote in message ... I need Vlookup to return a blank if the appropriate cell is empty. Thank you so much . . . .Y'all have been extremely helpful!! J. |
#4
|
|||
|
|||
Instead of returning a 0?
=if(vlookup()="","",vlookup()) And to get rid of the #n/a's: =if(iserror(vlookup()),"missing",if(vlookup()=""," ",vlookup())) Eaglered wrote: I need Vlookup to return a blank if the appropriate cell is empty. Thank you so much . . . .Y'all have been extremely helpful!! J. -- Dave Peterson |
#5
|
|||
|
|||
IF("lookupcell"="","",
VLOOKUP("lookupcell","lookuprange","returnvaluecol umn","false??")) "Eaglered" wrote in message ... I need Vlookup to return a blank if the appropriate cell is empty. Thank you so much . . . .Y'all have been extremely helpful!! J. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |