Multi vlookup

[ctrapper]

I know how to perform a singular vlookup, but now I am needing to expand it, and can't quite figure it out. Instead of just looking for one value and returning the values associated, I need the lookup to look in 2 columns: Example:

C2= WAS, and K2= HF

Column N Contains the City Names, Column O Contains the HF, and Column T contains a dollar amount.

So, what I am trying to accomplish is vlookup, and in this case, say look for WAS, and HF in columns N and O, and when found return Column T

Couple of notes, if any of the data, particularly the lookup data needs to be in side by side columns I can re-arrange.. i.e. if WAS is in C2, and HF needs to be in D2, I can do move my data.

[martindwilson]

=INDEX($t$1:$t$200, MATCH(c2 & k2, INDEX($n$1:$n$200 & $o$1:$o$200, 0), 0))

[ctrapper]

Great! Thanks for the help.. works like a charm!