Two Dimensional Lookup not working

[Djblois]

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,

 

[Brianwarnock]

Change the array in the Match to Sheet4!a1:a177

Brian

 

[Djblois]

That is what I had in there already. That is what the Named Range 'Prices' is! I tried to do it again but it still does not work.

 

[Brianwarnock]

No your array Prices is a 2 dimensional array a1:n177, in which case the Match uses the first row.

Brian

 

[Djblois]

Thank you, I did not realize that it was just the first column.

 

[Brianwarnock]

I would name the first Column as an array, say Style I think it was, but anyway I suspect you are already onto that given the rest of the workbook.

best wishes
Brian