Forum Discussion
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.
13 Replies
You can have a data validation list, in tab2, which references the list in the first tab; in the two cells to the right, a vlookup returning columns 2 & 3 of the table in tab1, respectively.
See attached.
Charla74 okay so how do i set it up?
what i want is this:
in row 1 i will data different numbers like 101, 102, 103 etc
in row 2 i will type that 101 has a working time of 7,53
in row 3 i will type that 101 has a netto time of 7,03
so when i select in tab 2 in a cell 101.........the next cell gives me 7,53 and the one next to that 7,03
how is the setup of it ?
i know how to make a list and how to add it into a cell
- 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.
