I believe this is a Index/Match formula?

[mcintoshmc]

I have the following on Sheet 1: A2:AG53

L2:AG2 is labeled 0 through 21

A3:A53 will be 300 through 350

Sheet 2:

J2 will contain a number 0-21

B5 will contain a number 300-350

J5 - I would like for it to display the corresponding cell based on the info placed in J2 and B5. For example: If J2 says 0 and B5 says 300, I would like J5 to display in info in L3

Can any one help?

 

[mcintoshmc]

I figured it out. Thanks

 

[Fluff]

How about

=INDEX(Sheet1!L3:AG53,MATCH(B5,Sheet1!A3:A53,0),MATCH(J2,Sheet1!L2:AG2,0))