Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help
Say I have data in column A and B where A1 relates to B1 (A2 to B2, etc.).
In J1 I have a drop down box with the data from column A. How do I get data from Column B to appear in say K1 as it relates to whatever I choose in my drop down from column A? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help
Try this:
With J1: (a value from Col_A) This formula returns the corresponding value from Col_B K1: =VLOOKUP(J1,$A$1:$B$100,2,0) Adjust range references to match your situation. Does that help? *********** Regards, Ron XL2002, WinXP "HD Hog" wrote: Say I have data in column A and B where A1 relates to B1 (A2 to B2, etc.). In J1 I have a drop down box with the data from column A. How do I get data from Column B to appear in say K1 as it relates to whatever I choose in my drop down from column A? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|