Forum Discussion
How to make an Array formula with multiple nested if statements ? is there a better way?
Hello, I am trying to create an IF formula that automates whether a destination is domestic or international. The destination will be entered by its airport code (BGI,LAS,) and a separate cell wi...
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)
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 |