• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

very basic user needing help finding what formula to use

S

shanlhill33

New Member
Hello, I am a very basic excel user and I need help on what kind of formula to use for a spreadsheet I am needing to create. I am wanting to create a spreadsheet that when I select a persons name from a drop down box, it will return and ID(one I have specified) in one cell, and in another cell it will give me a diagnosis code. All of this information will come from a table that I have created in another sheet. It will look something like this. Thanks.


Date Name ID DX code
 
Hi shanlhill33,


Welcome to the Forums!! You can use VLOOKUP() for this purpose. You can find details here:


http://chandoo.org/wp/2010/11/01/vlookup-excel-formula/


If you need any further assistance, fell free to ask.


Regards,
 
Using VLOOKUP(): If I have a drop down list of names, I select the name I want say, Sara. Then, when I select Sara, then in one cell it will give me her ID, and in another cell will be her DX code.
 
..Wait let me upload a sample file


Seee this:


https://dl.dropboxusercontent.com/u/60644346/Vlookup_Simple.xlsx


Regards,
 
Thank you so much for the help. Now that I see how it works then I understand it better. I think I was making it harder than what it really was!!! Thanks a Bunch!!!!SH
 
You must log in or register to reply here.
Back
Top