Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple "IF" statements in a formula
I am trying to develop a formula to look at (example): cell a9 and cell e9 on
the first tab, then find matching data on the 2nd tab (e.g., 1st tab cell a9 looks at 2nd tab 1st column and 1st tab cell e9 looks at 2nd tab 5th column = if these both find a match, then return the data on 2nd tab 6th column. Here is my formula: =IF(VLOOKUP(A9,'Defect Type'!A:H,1,FALSE),IF(VLOOKUP(E9,'Defect Type'!A:H,5,FALSE),'Defect Type'!F2,"FALSE")) I know the first row has matching data and should return data, but so far all I'm getting is an '#N/A'. Any thoughts? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple "IF" statements in a formula
Try this array formula** :
=INDEX(Sheet2!F1:F20,MATCH(1,(Sheet2!A1:A20=A9)*(S heet2!E1:E20=E9),0)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "lawandgrace" wrote in message ... I am trying to develop a formula to look at (example): cell a9 and cell e9 on the first tab, then find matching data on the 2nd tab (e.g., 1st tab cell a9 looks at 2nd tab 1st column and 1st tab cell e9 looks at 2nd tab 5th column = if these both find a match, then return the data on 2nd tab 6th column. Here is my formula: =IF(VLOOKUP(A9,'Defect Type'!A:H,1,FALSE),IF(VLOOKUP(E9,'Defect Type'!A:H,5,FALSE),'Defect Type'!F2,"FALSE")) I know the first row has matching data and should return data, but so far all I'm getting is an '#N/A'. Any thoughts? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Formula for Multiple "IF's" or maybe "COUNTIF's"??? | Excel Discussion (Misc queries) | |||
Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) | |||
How can I have multiple "If" statements in one formula? | Excel Discussion (Misc queries) |