Forum Discussion
How to make an Array formula with multiple nested if statements ? is there a better way?
Thank you , So I did do that but one of the vlookups keeps returning the wrong value and I don't know why.
John Sokolowski , if your airports are in columns A and B starting from first row where are column names, when it could be
=IF(ISNUMBER(MATCH(I1,$A:$A,0)),$A$1,IF(ISNUMBER(MATCH(I1,$B:$B,0)),$B$1,"no such"))
- John SokolowskiMay 08, 2019Copper Contributor
This is my code
I have a table on the master sheet with 2 columns.
When I run the below formula for "PSE" which is supposed to = DOM it returns "INTL". the formula is taking the information from the cell above PSE on the master list and returning that value instead of the value for PSE it is giving me the value for POS .
the table is sorted in alphabetical order
=VLOOKUP(C2825,'Master Sheet'!$A$2:$C$75,2,TRUE)
- SergeiBaklanMay 08, 2019Diamond Contributor
John Sokolowski , if VLOOKUP returns the value above it means it didn't find PSE. Check manually if the match like
=C2825='Master Sheet'!$A$66
(or where is that value in master sheet) if it returns TRUE or FALSE. That could be extra space like "PSE ", or non-printable character, or like.
- John SokolowskiMay 08, 2019Copper Contributor
this is what I am getting I put the code in one of the cells. I used Hlookup to see if it comes out differently but it doesn't .
Org Region SEA DOM STI INTL SDQ INTL KIN INTL BTV DOM LAS DOM PSE #N/A(=HLOOKUP(C2827,Sheet3!$A$2:$BV$3,2,FALSE) SFO DOM BUR #N/A STI INTL SDQ INTL FLL DOM BQN DOM ONT DOM