Help Me

  • Thread starter Thread starter Hunter_Cooley
  • Start date Start date
H

Hunter_Cooley

..Hello,

I want to search in say COLUMN 2 for a unique letter say A and then
want to search in ROW 3 for another unique (to the row) letter sa
C....and where horizontal from A and Vertical from C meet that is th
info I want to retreive...

Help would be most appreciated....

Thx

Hun
 
Hi

Try this:
=OFFSET(G2,MATCH(G14,G3:G9),MATCH(G15,H2:L2))

with your column letter in G14, your row letter in G15, and your the top
left square of your 'table' in G2 (with the table covering G2 to L9).

Andy.
 
Back
Top