| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Checking a second lookup condition
=IF(OR(A1="",NOT(ISNUMBER('DOWNLOAD WO SHORTAGE LIST'!D9))),"",'DOWNLOAD WO
SHORTAGE LIST'!D9 "Obwan" wrote: =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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Checking a second lookup condition
Faster than a speeding bullet. Superman had nothing on you.
Brilliant, Thank you. "Teethless mama" wrote: =IF(OR(A1="",NOT(ISNUMBER('DOWNLOAD WO SHORTAGE LIST'!D9))),"",'DOWNLOAD WO SHORTAGE LIST'!D9 "Obwan" wrote: =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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Checking a second lookup condition
Another suggestion is a custom number format of
mm/dd/yyyy;; the actual cell value would still be 0 (or 1/0/1900), but would not be shown on screen. "Obwan" wrote: =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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Checking a second lookup condition
Nice and simple. Appreciate your help.
"JMB" wrote: Another suggestion is a custom number format of mm/dd/yyyy;; the actual cell value would still be 0 (or 1/0/1900), but would not be shown on screen. "Obwan" wrote: =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 |
| Reply |
| 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 | |||
Hybrid Mode
