Using Data Validation and VLOOKUP

[Jackie66613]

I have created a worksheet for a pizza parlor where I used Data Validation to have a dropdown menu for both type of pizza and the size. I am having trouble getting the VLOOKUP to work so that it gives the correct price for that type and size of pizza.

[Richard Buttrey]

...so are you going to share your workbook with us?

[Tony Valko]

Set up a table something like this:

Data Range

	A	B	C	D	E
1		Small	Medium	Large	Xtra Large
2	Type1	10	20	30	40
3	Type2	12	22	32	42
4	Type3	14	24	34	44
5	Type4	16	26	36	46
6
7
8
9
10	Type2	Large	32

This formula entered in C10:

=VLOOKUP(A10,A1:E5,MATCH(B10,A1:E1,0),0)

[Jackie66613]

...so are you going to share your workbook with us?

I guess that would have helped, I thought I did that. Hopefully this time it will take. Its the tab with Prob-4

[Richard Buttrey]

Hi,

In I3 (or anywhere for that matter)

Please Login or Register  to view this content.

[Jackie66613]

Mr. Buttrey, this worked perfect! I will go through each part to ensure I understand it. Thank you again for your help and solution!