Forum Discussion
make a list in tab 1 and use it in tab 2
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.
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
- in your example you wrote
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.