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 •


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

Report •

#2
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.


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

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

=VLOOKUP(C1,Sheet2!$A$1:$B$3,2,0)

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


Report •

Related Solutions


Ask Question