PDA

View Full Version : 2 dimensonial lookup formula not working


Djblois
11-06-2009, 07:17 AM
I am creating a spreadsheet that will look up prices based on style and model#. I got everything working on the form except the final 2 dimensional lookup to find the price.

Please Help
Bob Phillips
11-06-2009, 10:47 AM
Try

=INDEX(Prices,MATCH($E4,INDEX(Prices,0,1),0),MATCH($F4,INDEX(Prices,1,0),0) )