| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating IF with OR
You're welcome.
Bernie Worked perfectly. Thank you. "Bernie Deitrick" wrote: Joe, =IF(OR(ISBLANK($A3),ISERROR(MATCH($A3,Sheet1!$A$3: $A$9370,FALSE))),"",OFFSET(Sheet1!$A$3,MATCH(Sheet 2!A3,Sheet1!$A$3:$A$9370,0)-1,1,-1,-1)) HTH, Bernie MS Excel MVP "Joe Gieder" wrote in message ... First, thank you for the help. I have this formula: =IF(OR(ISBLANK($A3),($A3<Sheet1!$A$3:$A$9370)),"" ,OFFSET(Sheet1!$A$3,MATCH(Sheet2!A3,Sheet1!$A$3:$A $9370,0)-1,1,-1,-1)) and what I want to do is, if A3 is not found in Sheet1!$A$3:$A$9370 I want the cell to be blank, if it does find it I want the data filled in. What happens is the result is always blank. Did I over look something? TIA Joe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a pdf | Excel Discussion (Misc queries) | |||
| Creating Id | Excel Worksheet Functions | |||
| Creating a formula | Excel Worksheet Functions | |||
| Really need help creating pop ups | Excel Discussion (Misc queries) | |||
| Creating | Excel Discussion (Misc queries) | |||
Hybrid Mode
