Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it even possible?
Ok I have an excel problem I am trying to figure out if it is even possible to do. I am going to have column A where data will be entered.. then I am going to have a B column where all possible entries for A will be listed.. then I also have a C column to the right of B column that has numbers that correspond to each item in B column. What I want to do is have column D, that refers to the entry in column A, matches it in column B and the displays the corresponding entry from column C. Anyone understand and think this might be possible? Thanks -Josh -- Pyronius ------------------------------------------------------------------------ Pyronius's Profile: http://www.excelforum.com/member.php...o&userid=31640 View this thread: http://www.excelforum.com/showthread...hreadid=513309 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it even possible?
OK, let's do this in steps.
In column B, enter the data that you want to allow in Column A. In Cell A2, do the following: Data | Validations | Settings Tab | Choose ALLOW LIST Select the source of the list in column B and OK Copy A2 down as necessary. Enter the info to match B in column C. In column D2, enter the following =VLOOKUP(A2,B$2:C$11,2,FALSE) Keep in mind that B$2:C$11 may change depending on the range of your values for column A and the match for column B. Copy D2 down. Good luck! Barb Reinhardt "Pyronius" wrote: Ok I have an excel problem I am trying to figure out if it is even possible to do. I am going to have column A where data will be entered.. then I am going to have a B column where all possible entries for A will be listed.. then I also have a C column to the right of B column that has numbers that correspond to each item in B column. What I want to do is have column D, that refers to the entry in column A, matches it in column B and the displays the corresponding entry from column C. Anyone understand and think this might be possible? Thanks -Josh -- Pyronius ------------------------------------------------------------------------ Pyronius's Profile: http://www.excelforum.com/member.php...o&userid=31640 View this thread: http://www.excelforum.com/showthread...hreadid=513309 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it even possible?
Thanks very much works great! -- Pyronius ------------------------------------------------------------------------ Pyronius's Profile: http://www.excelforum.com/member.php...o&userid=31640 View this thread: http://www.excelforum.com/showthread...hreadid=513309 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it even possible?
You are quite welcome.
"Pyronius" wrote: Thanks very much works great! -- Pyronius ------------------------------------------------------------------------ Pyronius's Profile: http://www.excelforum.com/member.php...o&userid=31640 View this thread: http://www.excelforum.com/showthread...hreadid=513309 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|