LOOKUP _ Pulldown menu

  • Thread starter Thread starter kp_27
  • Start date Start date
K

kp_27

I have a sheet with an array and wants to lookup a particular valu
against a cell and use that information in another sheet.

Eg:

A $10
B $20
C $30
D $40
E $50 .....and so on

The sheet is very extensive and will change occassionally.

Now, I want this information in another sheet when I enter say "A" in
cell, the corresponding value to be entered in the adjacent cell.
tried Vlookup but didnt work. Cant use "IF" since the range is ver
large. Any idea how it can be done

I want to try using a Pull down menu to choose "A, B, or C..." and th
cell next to it gets the value from the other sheet. But I lac
programming knowledge to use Active X..

Any help will be appreciated
K
 
KP

VLOOKUP wil handle that.

Basic example.....

Enter your letters down column A
Enter the corresponding $ numbers down Column B

In D1 enter =VLOOKUP(C1,$A$1:$B$26,2,FALSE)

Now enter a letter in C1. Result in D1 will be the $ number.

To make for less typing in C1........

Select C1 then Data>Validation>Allow>List. Select the A1:A26 Range. Check
"ignore blanks" and "in-cell dropdown" then OK your way out.

C1 will now have a dropdown list to pick the letters from.

You can hide Columns A and B if wish to.

Your ranges and columns may vary.

Gord Dibben XL2002

I have a sheet with an array and wants to lookup a particular value
against a cell and use that information in another sheet.

Eg:

A $10
B $20
C $30
D $40
E $50 .....and so on

The sheet is very extensive and will change occassionally.

Now, I want this information in another sheet when I enter say "A" in a
cell, the corresponding value to be entered in the adjacent cell. I
tried Vlookup but didnt work. Cant use "IF" since the range is very
large. Any idea how it can be done

I want to try using a Pull down menu to choose "A, B, or C..." and the
cell next to it gets the value from the other sheet. But I lack
programming knowledge to use Active X..

Any help will be appreciated
KP
Click to expand...

Gord Dibben XL2002
 
Thanks ...it worked...but I couldnt do data validation to anothe
sheet....
Is there a way to do that...
I want my data to be in a seperate sheet so that no one messes wit
it....
Thanks agai
 
Back
Top