Simple selection, but hey, I'm no guru!!
I have a small table of data ranging from column A to column D running from cells 5 to 11. Lower down the sheet I need to select from the items in column A and I am currently using a "Validation" drop down box to do this. I would like to populate another cell with the data on the same row on column D.
Eg A B C D 5 egg scrambled 6 bacon fried 7 sausage grilled 8 toast toasted etc If I select "egg" from my drop down list in cell B17, I would like to have "scrambled" entered into cell B18. Sorry if this doesn't test you too much, and many thanks in advance to those who help out!! |
Try...
=VLOOKUP(B17,A5:D8,4,0) OR =INDEX(D5:D8,MATCH(B17,A5:A8,0)) Hope this helps! In article , Director wrote: I have a small table of data ranging from column A to column D running from cells 5 to 11. Lower down the sheet I need to select from the items in column A and I am currently using a "Validation" drop down box to do this. I would like to populate another cell with the data on the same row on column D. Eg A B C D 5 egg scrambled 6 bacon fried 7 sausage grilled 8 toast toasted etc If I select "egg" from my drop down list in cell B17, I would like to have "scrambled" entered into cell B18. Sorry if this doesn't test you too much, and many thanks in advance to those who help out!! |
All times are GMT +1. The time now is 03:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com