| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Vlookup HELP
I have a drop down menu that I use for parts and pricing. The problem I have
is on my quote sheet it won't let me add up all of my pricing because not all fields are filled in some are blank and when they are blank the total is #N/A not allowing you to add up #N/A mixed with numbers or it will come up #N/A. =VLOOKUP(SHELVING!J22,Cost!A1:B16,2,FALSE) Is there a way an emty cell can be equal to zero without having to add and select zero from a drop down menu giving the zero a $.00 cost. I hope you can understand what i am doing. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP Conversion from Excel 2003 to Excel 2007 | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
