Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup and IF?
I am using vlookup to calculate a value which is wroking great. However, if another cell has a zero value, I want my vlookup cell to be zero as well. cell D22...=VLOOKUP(D18,B33:C49,2) I want to add to the above formula... if another cell (D21) calculation result is zero, make this cell (D22) zero as well. What would the new formula be? Thank you! Vance -- Vance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |