View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Curt D. Curt D. is offline
external usenet poster
 
Posts: 20
Default lookup by column & row

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