lookup by column & row
You probably want to use a combination of Vlookup and Match to do that
=Vlookup("BOS", A2:D4, match("2/3", B1:B4, false) + 1, false)
or something like that...
--
HTH...
Jim Thomlinson
"Curt D." wrote:
Is there a formula or VBA coding that will allow me to serch a range that has
a criteria for the row and another one by the column? For example I have
2/1 2/2 2/3
ATL 40 45 35
BOS 23 9 0
CVG 4 12 10
I need to search this range above and say I need the number for BOS on 2/2,
how could I do this? Any help would be appreciated. thanks
|