VLOOKUP using text

[tafatafa]

Hi,

I have two sheets in a workbook. (Sheet 1 & Sheet2). Sheet 2 contains a table which start with a text (column1), such as Bulk materail. Column2 & 3 contains relevent information related to text (bulk material). My issue is, in sheet1, when I create a dropdown list of the column1 in sheet 2, how can I bring the corresponding data as well. Because it is a dropdown liste, user can choose any of the text of column1 in sheet 2. so, how can I ensure that each time a text is selected, corresponding data is also populated in sheet 1.

Thanks in advance.

 

[Kevin@Radstock]

Hi tafatafa


Use the INDEX & MATCH functions.

 

[jason]

=VLOOKUP(A1,SHEET2!A1:C100,2,FALSE)


The above formula assumes that the value you are looking for is in A1, the table of data that your wanting to access is on Sheet2 and in cells A1:C100. NOTE: you can obviously adjust any of these cell references to match the layout of your spreadsheets/data. the '2' argument (right before 'FALSE' indicates that you want to pull the content from the first column of your data table (Sheet2!A1:C100). So once it finds the content in A1 in the first column of your DataTable, it will go to the second column and return that value. The last argument, 'FALSE' indicates that you want an exact match to be found. This (can also enter a 0 I believe) is typically the most common.


for this to work for all records on your Sheet 2, every row needs to be unique. So you cant have "BULK" in A2 and A10 because it will always find the A2 first and return that informaiton. there are ways around this if this could be the case for you.


let us know how this works.

 

[SirJB7]

Hi, tafatafa!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


Regards!