Lookup problem

  • Thread starter Thread starter foilprint0
  • Start date Start date
F

foilprint0

I need to cross reference from rows 1 to 9 with columns a to p.
so rows 1 to 9 will be 100, 80, 60, 50 and the columns is 50, 49, 48
47, 46, 45 and so on.
I am looking at the value of row 2 (80) and column d (48)

can anyone hel
 
=INDEX(A1:P9,MATCH(80,A1:A9,0),MATCH(48,A1:P1,0))

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top