Mervyn

Maybe:-
Col A B C D
FL300 FL310 FL320
100 180 178 176
200 179 177 175
300 175 174 172


=SUMPRODUCT((A2:A4=F1)*(B1:D1=F2)*(B2:D4))

Where f1 & F2 are your 2 input values.

Mike
"Mervyn Edwards" wrote:

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.