| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
conditional statement
I currently have a VLOOKUP function set up in a cell. I am interested in
setting up a conditional statement that goes something like "If the drop-down cell is null, display nothing, else use the VLOOKUP function defined" This is purely for aesthetic reasons, I don't want to have "#N/A" displayed in the VLOOKUP cells when no selction is made in the respective drop down box. If there is an easier way to display a blank cell when value is null, that will work too. I'm kind of at a loss. |
|
#2
|
|||
|
|||
|
=if(isblank(a1),"",vlookup.....
******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "mjstizzle" wrote in message ... I currently have a VLOOKUP function set up in a cell. I am interested in setting up a conditional statement that goes something like "If the drop-down cell is null, display nothing, else use the VLOOKUP function defined" This is purely for aesthetic reasons, I don't want to have "#N/A" displayed in the VLOOKUP cells when no selction is made in the respective drop down box. If there is an easier way to display a blank cell when value is null, that will work too. I'm kind of at a loss. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I use HYPERLINK in a conditional statement between sheets | Excel Worksheet Functions | |||
| Conditional Statement with ANDs | Excel Discussion (Misc queries) | |||
| IF Statement that's conditional on multiple IF Stmts in other cell | Excel Worksheet Functions | |||
| How do I write a conditional statement in Excel to count if two c. | Excel Worksheet Functions | |||
| Conditional formatting based on if statement. | Excel Worksheet Functions | |||
Linear Mode
