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 can you please explane me visual according to my file i send you ?
file: diensten1 is tab 1
file vlookup is 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.
 
- Happy I could help! 😊
Charla74 now i realy got it !!!!! i made a little test and it works ...........i want to thank you so much !!!
you are the best