| 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 :) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Empty cell in vlookup
=IF(A21="","",if(VLOOKUP(A21,'PN Source
Code'!$A$1:$H$25,8,FALSE)="","",VLOOKUP(A21,'PN Source Code'!$A$1:$H$25,8,FALSE))) -- Please click "yes" if this post helped you! Greatly appreciated Eva "confused" wrote: 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 :) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Empty cell in vlookup
Thanks you Eva, this was very helpful :)
"Eva" wrote: =IF(A21="","",if(VLOOKUP(A21,'PN Source Code'!$A$1:$H$25,8,FALSE)="","",VLOOKUP(A21,'PN Source Code'!$A$1:$H$25,8,FALSE))) -- Please click "yes" if this post helped you! Greatly appreciated Eva "confused" wrote: 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 :) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Empty cell in vlookup
you are very welcome.
-- Please click "yes" if this post helped you! Greatly appreciated Eva "confused" wrote: Thanks you Eva, this was very helpful :) "Eva" wrote: =IF(A21="","",if(VLOOKUP(A21,'PN Source Code'!$A$1:$H$25,8,FALSE)="","",VLOOKUP(A21,'PN Source Code'!$A$1:$H$25,8,FALSE))) -- Please click "yes" if this post helped you! Greatly appreciated Eva "confused" wrote: 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 :) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Empty cell in vlookup
I was excited to see this post as I was trying to figure out the same thing!
MY CODE (Excel 2007): =IF(ISERROR(VLOOKUP(K6,Developers!$D$5:$R$143,6,0) ),"",VLOOKUP(K6,Developers!$D$5:$R$143,6,0)) USING YOUR IDEA: =IF(K6="","",if(VLOOKUP(K6,Developers!$D$5:$R$143, 6,FALSE)="","",VLOOKUP(K6,Developers!$D$5:$R$143,6 ,FALSE))) However, I get a #N/A error now when before it correctly filled the cell with the information. In some instances, there is no data in the other sheet, so it displays 0. I, like "confused", want to replace the 0 with a blank. Thanks! "Eva" wrote: =IF(A21="","",if(VLOOKUP(A21,'PN Source Code'!$A$1:$H$25,8,FALSE)="","",VLOOKUP(A21,'PN Source Code'!$A$1:$H$25,8,FALSE))) -- Please click "yes" if this post helped you! Greatly appreciated Eva "confused" wrote: 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 :) |
| Reply |
| 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) | |||
Hybrid Mode
