Combine Vlookup and Hlookup?

[scottiedawg4]

Can I return the value of a cell based off of both a column and a row?

For example, if I have x, y, z in A2:A4 and j, k, l in B1:D1, can I return the cell that has both y and j?

 

[VoG]

Try INDEX and MATCH http://j-walk.com/ss/excel/usertips/tip020.htm

 

[scottiedawg4]

Thanks! INDEX and MATCH worked perfectly.