Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return a value based on another cell
I am trying to retun a value for a cell based on another cell that will have
approx. 100 possible values. The first cell is a list of vendor names (which I have in a drop down menu) and the second is a vendor # (which will always correspond to a specific vendor name). I would like the vendor # to automatically fill in depending on which vendor name I choose from the drop down vendor list. Any help is much appriciated, msm89 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return a value based on another cell
You can use the Vlookup() function.
Check here and post back with any questions: http://www.contextures.com/xlFunctions02.html -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "msm89" wrote in message ... I am trying to retun a value for a cell based on another cell that will have approx. 100 possible values. The first cell is a list of vendor names (which I have in a drop down menu) and the second is a vendor # (which will always correspond to a specific vendor name). I would like the vendor # to automatically fill in depending on which vendor name I choose from the drop down vendor list. Any help is much appriciated, msm89 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
Need cell formulas to return the day of every Monday in a month based on year entered | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
HELP| populate cell with particular value based on multiple condit | Excel Worksheet Functions |