Index And Match Functions

My Dear Excel Gurus:

I am using the following formula in my spreadsheet to look up values from a 2x93 range:

INDEX(P1:Q93,MATCH(H347,P1:P93,0),2)

I need to modify the formula to, instead of matching the contents of H347, match the contents of column H and the current row number.

Can you please tell me how to modify the H347 entry to do this?

Your help will be greatly appreciated.

Ansonicus

If you use this formula in row 347

=INDEX(P$1:Q$93,MATCH(H347,P$1:P$93,0),2)

If you copy up or down H347 will change automatically but the other ranges will remain unchanged. You could also employ VLOOKUP, i.e.

=VLOOKUP(H347,P$1:Q$93,2,0)

Works like a champ. I really appreciate that, my friend.

It probably was easy for you, but I hadn't a clue how to do it.