Hello,
I'd like to combine these two IF statements:
=IF($F$5="Los Angeles",(INDEX(Finders!B24:I43,MATCH(C5,Finders!A24:A43,0),MATCH(D5,Finders!B23:I23,0))))
=IF($F$5="Chicago",(INDEX(Finders!B2:I21,MATCH(C5,Finders!A2:A21,0),MATCH(D5,Finders!B1:I1,0))))
I'm simply trying to get a different result in a cell, based on what text is in a cell.
Thanks!
Bob
=IF(F5="","",IF($F$5="Los Angeles",(INDEX(finders!B24:I43,MATCH(C5,finders!A24:A43,0),MATCH(D5,finders!B23:I23,0)),IF($F$5="Chicago",(INDEX(finders!B2:I21,MATCH(C5,finders!A2:A21,0),MATCH(D5,finders!B1:I1,0)))))))
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
I am not sure about your context but adding the "IF(OR(" you should be able to combine these.
=IF(or($F$5="Los Angeles,$F$5="Chicago),IF($F$5="Los Angeles",(INDEX(Finders!B24:I43,MATCH(C5,Finders!A24:A43,0),MATCH(D5,Finders!B23:I23,0)))),IF($F$5="Chicago",(INDEX(Finders!B2:I21,MATCH(C5,Finders!A2:A21,0),MATCH(D5,Finders!B1:I1,0)))))
Hello!
Thanks for the replies.
The first suggestion gave me nothing different than I had when separating the two IF statements.
The second suggestion returned a "#VALUE" error.
Bob
Last edited by Bob Lankin; 10-05-2013 at 04:51 PM.
Try this
=IF(F5="","",IF($F$5="Los Angeles",INDEX(Finders!B24:I43,MATCH(C5,Finders!A24:A43,0),MATCH(D5,Finders!B23:I23,0)),IF($F$5="Chicago",INDEX(Finders!B2:I21,MATCH(C5,Finders!A2:A21,0),MATCH(D5,Finders!B1:I1,0)))))
Dat worked!
Thanks very much,
Alan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks