Excel Lookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ginny - 30 May 2008 16:44 GMT

I have a worksheet with a dropdown list of item codes in Col A.
Once that the code is selected, I need the item description in Col D and the
item price in Col F.

I have a seperate worksheet that has 3 columns for the code, description,
and price.

Thanks!

Reply to this Message

Gary''s Student - 30 May 2008 16:50 GMT

Use the VLOOKUP() function. See:

http://www.contextures.com/xlFunctions02.html

Signature

Gary''s Student - gsnu200789

> I have a worksheet with a dropdown list of item codes in Col A.
> Once that the code is selected, I need the item description in Col D and the
[quoted text clipped - 4 lines]
>
> Thanks!

Reply to this Message

L. Howard Kittle - 30 May 2008 17:55 GMT

Hi Ginny,

Select two cells where you want the description and price returned. While
selected enter the following formula, adjusting the ranges to suit your
sheet.

=VLOOKUP(G20,D20:F22,{2,3},0)

Now use Ctrl+Alt+Enter to commit, you will get { } around the formula in the
formula bar.

If you need to change the formula select both cell and make the change in
the formula and use Ctrl+Alt+Enter again.

HTH
Regards,
Howard

>I have a worksheet with a dropdown list of item codes in Col A.
> Once that the code is selected, I need the item description in Col D and
[quoted text clipped - 5 lines]
>
> Thanks!

Reply to this Message