View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mervyn Edwards Mervyn Edwards is offline
external usenet poster
 
Posts: 3
Default Cross referencing

I am trying to pull the information from the cell at the intersection between
a particular row and column. The identifier for which row and column needs to
come from an input value. I have tried various incarnations of vlookup and
hlookup with match, but cannot get a result.

Example: Input Values would be 200 and FL310 to establish an answer of 177

FL300 FL310 FL320
100 180 178 176
200 179 177 175
300 175 174 172

Any help would be much appreciated.