If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
return a value based on another cell
What you want is the VLOOKUP function. for example.........in G1:G99 put
your vendor names in alphabetical order. In H1:h99 put their corresponding vendor codes. then put any vendor name in A1, and put this formula in B1... =VLOOKUP(A1,G1:H99,2,FALSE) hth Vaya con Dios, Chuck, CABGx3 "msm89" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|