View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mjsam mjsam is offline
external usenet poster
 
Posts: 4
Default Cross Reference Formula

I need to find a formula that first looks across the top row to find a number
and then down the first column and results with the intersecting cell.
1 2 3 4 5
a 3 6 7 8 4
b 2 5 7 5 6

Excmple: when i reference 3-b, I need the result to be 7. THis is HLookup
and V lookup, but how do i combine these two formulas? HELP!