| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Checking a second lookup condition
=IF(A9="","",'DOWNLOAD WO SHORTAGE LIST'!D9)
This formula looks in Cell A9 for a works order # If it is blank it will return blank Else go to worksheet 'DOWNLOAD WO SHORTAGE LIST' Pick up the date in cell D9 My question: How do I expand this statement to include IF D9 in 'DOWNLOAD WO SHORTAGE LIST' has no date then Blank else date. Presently it returns the excel default 01/01/1900 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple condition lookup and match cell format | Excel Worksheet Functions | |||
| Lookup function with condition in time series data | Excel Worksheet Functions | |||
| Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
| Can I set up a formula to lookup a value for a condition | Excel Discussion (Misc queries) | |||
| Problem with IF condition or vector lookup? | Excel Worksheet Functions | |||
Threaded Mode
