VLOOKUP using 2 cells to determine the answer.

Lets see if I can example this.

I need excel to look up Width X Height using my chart to give me the price.

So here's my chart
Width Height Price
1 1 30
2 1 60
1 2 60
3 1 90
2 2 120
4 1 120
3 2 180
4 2 240

Now in excel I have Width as its own cell, Height as its own Cell and the price as its own cell. Is there a formula for VLOOKUP to use two different cells at the same time?

For Example using cells:
A3 is my width, width is 2
B3 is my height, height is 1
C3 is my price, so according to my chart above my price is 60

Can VLOOKUP determine my price based on cell A3 and B3?

Hopefully I explained that well enough.

See attached spreadsheet.

VLOOKUP using 2 cells to determine the answer.xlsx

Pete

Greatly Appreciated, thank you

Hiya,

Can the 'Get Price' be given if say the input was 1.5? ie round that up to next available full number? (2)

Thanks!

You might try adding the =CEILING function around fields that might contain other than a whole number. See if that works for you.

Pete

Originally Posted by pmcdee88

Hiya,

Can the 'Get Price' be given if say the input was 1.5? ie round that up to next available full number? (2)

Thanks!

Format the cell as 0 decimals

Btw wouldnt it be better to use drop down as the hight and width and vlookup for the price