| 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 :) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Empty cell in vlookup
Text.
The user selects a course developer from a drop-down box on the Development! sheet in Column K (which is populated from data in the Courses! sheet). After making a selection, the developer's e-mail addres, for example, appears in Column L. The spreadsheet gets this information from the Developers! sheet. With the formula I used before, it works correctly. It just puts 0 in the cell if there is no e-mail address currently in the Developers! sheet. I just want to replace the 0 with a blank, until an e-mail address is entered in the Developers! sheet. Thanks! "T. Valko" wrote: What type of data does your lookup formula return, is it text or numeric or can it be either? -- Biff Microsoft Excel MVP "Art" wrote in message ... 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 :) . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Empty cell in vlookup
Try this...
=IF(COUNTIF(Developers!$D$5:$D$143,K6),T(VLOOKUP(K 6,Developers!$D$5:$R$143,6,0)),"") -- Biff Microsoft Excel MVP "Art" wrote in message ... Text. The user selects a course developer from a drop-down box on the Development! sheet in Column K (which is populated from data in the Courses! sheet). After making a selection, the developer's e-mail addres, for example, appears in Column L. The spreadsheet gets this information from the Developers! sheet. With the formula I used before, it works correctly. It just puts 0 in the cell if there is no e-mail address currently in the Developers! sheet. I just want to replace the 0 with a blank, until an e-mail address is entered in the Developers! sheet. Thanks! "T. Valko" wrote: What type of data does your lookup formula return, is it text or numeric or can it be either? -- Biff Microsoft Excel MVP "Art" wrote in message ... 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 :) . |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Empty cell in vlookup
Perfect. Thank you VERY much!!!
"T. Valko" wrote: Try this... =IF(COUNTIF(Developers!$D$5:$D$143,K6),T(VLOOKUP(K 6,Developers!$D$5:$R$143,6,0)),"") -- Biff Microsoft Excel MVP "Art" wrote in message ... Text. The user selects a course developer from a drop-down box on the Development! sheet in Column K (which is populated from data in the Courses! sheet). After making a selection, the developer's e-mail addres, for example, appears in Column L. The spreadsheet gets this information from the Developers! sheet. With the formula I used before, it works correctly. It just puts 0 in the cell if there is no e-mail address currently in the Developers! sheet. I just want to replace the 0 with a blank, until an e-mail address is entered in the Developers! sheet. Thanks! "T. Valko" wrote: What type of data does your lookup formula return, is it text or numeric or can it be either? -- Biff Microsoft Excel MVP "Art" wrote in message ... 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 :) . . |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Empty cell in vlookup
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Art" wrote in message ... Perfect. Thank you VERY much!!! "T. Valko" wrote: Try this... =IF(COUNTIF(Developers!$D$5:$D$143,K6),T(VLOOKUP(K 6,Developers!$D$5:$R$143,6,0)),"") -- Biff Microsoft Excel MVP "Art" wrote in message ... Text. The user selects a course developer from a drop-down box on the Development! sheet in Column K (which is populated from data in the Courses! sheet). After making a selection, the developer's e-mail addres, for example, appears in Column L. The spreadsheet gets this information from the Developers! sheet. With the formula I used before, it works correctly. It just puts 0 in the cell if there is no e-mail address currently in the Developers! sheet. I just want to replace the 0 with a blank, until an e-mail address is entered in the Developers! sheet. Thanks! "T. Valko" wrote: What type of data does your lookup formula return, is it text or numeric or can it be either? -- Biff Microsoft Excel MVP "Art" wrote in message ... 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) | |||
Linear Mode
