lookup table? match formula?

April 15, 2009 at 07:54:38
Specs: Windows XP
I am trying to create a spreadsheet that has a drop down box in column C containing clothing sizes. When that size has been selected, I want the price for that size to automatically show up in column D. In a separate worksheet I have the sizes and the corresponding price, but don't know how to setup the first spreadsheet to pull in that price. Any ideas?

See More: lookup table? match formula?

Report •

April 15, 2009 at 08:11:33
I figured it out using vlookup. Thanks.

Report •

April 15, 2009 at 08:21:53
The table that has the sizes and prices must have the item you are looking up in the first column of the range that you are doing the VLOOKUP from.

    A          B
1   S      $15.00
2   M      $10.00
3   L      $ 5.00

With your drop down in C1, D whatever should contain:


Read the Help file on VLOOKUP for a more detailed explanation.

Report •

Related Solutions

Ask Question