Drop down list - format

**rdaled** · 12-21-2006, 09:46 AM

I have created a drop down list with part numbers in B2. I want C2 to automatically show the corresponding price of that part number. I have all the part numbers listed in column B40:96 and the corresponding prices listed in column C40:96. How do I format C2?

Thanks!

**michaelw00d** · 12-21-2006, 09:54 AM

Originally Posted by rdaled

I have created a drop down list with part numbers in B2. I want C2 to automatically show the corresponding price of that part number. I have all the part numbers listed in column B40:96 and the corresponding prices listed in column C40:96. How do I format C2?

Thanks!

Hi, you just need to use a LOOKUP table.

=LOOKUP(B2,B40:B96,C40:C96)

Put that into cell C2 and it should return the price of B2 looking in the table you specified

Michael.

**rdaled** · 12-21-2006, 10:21 AM

I copied the LOOKUP formula into C2 and it gives a price but it isn't correct. In fact the price it gives isn't even one listed in C40:96. I must have something screwed up. At least I'm closer than I was.

**michaelw00d** · 12-21-2006, 10:32 AM

Originally Posted by rdaled

I copied the LOOKUP formula into C2 and it gives a price but it isn't correct. In fact the price it gives isn't even one listed in C40:96. I must have something screwed up. At least I'm closer than I was.

=VLOOKUP(B2,B40:C96,2,FALSE)

That should do the trick...not use to using lookup tables :P

Michael.