Forum Discussion
Solved
make a list in tab 1 and use it in tab 2
i have in tab 1 a list of 40 lines and 3 rows. in tab 2 i want to select the data of row 1 and then excel needs to fill row 2 and 3 automatic. how to do this ?
So, the first Vlookup would be in cell B1 of Tab2 and should look like the attached image......however, I only used 1 row and 3 columns of data which you would need to adjust accordingly (you can actually do this with the mouse and select the range that way). Your Tab2 cell A1 would be the Data Validation list but I think you already know this part. Hope this makes sense.
I added an example worksheet to my last reply, maybe it wasn’t there when you viewed the first message - check it out and see if it suits your requirements.
in your example you wrote
105...........105_h2.............105_h2
and what i want is h2...........h3
105...........105_h2.............105_h2
and what i want is h2...........h3
- My laptop just crashed so not able to check the formula but if it’s the same result in both columns B & C then the formula in C needs to be adjusted where it says ,2 - just change to , 3 ( which means return column number 3 from the array / table)
Charla74 in collum 1 is the data what i will select in a list at tab 2
in collumn 2 is data 101text_h1 and in collomn 3 is data 101text_h2 ( so 2&3 are different, but both are connected to collumn 1
101............ 101textH1.........101textH2
102............ 102textH1.........102textH2
etc. etc.
- bommelmans
If you replace my sample data with some of your own you should get a better idea of how it should work. Don’t forget that you will need to adjust the array / range in the VLOOKUP formula to suit your data (also, changing your array to table format will ensure the formulae are dynamic and include any new entries to your list).