| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup problem when value absent
Thank you DazzaData. It helped.
"DazzaData" wrote: Hi, You kinda answered your own question in the last para:) IF (VLOOKUP#1<0,VLOOKUP#1, (IF VLOOKUP#2<0,VLOOKUP#2,VLOOKUP#3) ) Actually there may be a whole other way of dealing with this issue rather than nest ifs and vlookups, but you would need to set out the problem more fully for us Cheers "new_121" wrote: Hi, Does anyone know, what formula I should use, if I would like to vlookup for certain thing (name) and return the value in column 1 if the value is different from zero, but look at the column 2 in case vlookup in column 1 is zero. And if vlookup in column 1 and column 2 turn to be zero then vlookup the value in column 3 - if that is empty as well then return "" (nothing). Please help me, because I'm stuck with this formula :( |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP problem with using a - | Excel Worksheet Functions | |||
| VLOOKUP problem | Excel Worksheet Functions | |||
| VLOOKUP problem | Excel Worksheet Functions | |||
| The # in my vector is absent from my array. Can I make it 0? | Excel Worksheet Functions | |||
| Count for present & absent days | Excel Discussion (Misc queries) | |||
Threaded Mode
