News0 min ago
Excel query
I have a spreadsheet (Spreadsheet A) with a column of registration numbers and then a column next to it with mileages. I have a separate spreadsheet (Spreadsheet B) with the same registrations (plus 20 or 30 other registration not on the first spreadsheet) in one column and drivers name in the next column. Can anyone tell me a formula or way of automatically pulling the names of the drivers from the spreadsheet B over to Spreadsheet A so that the names of the drivers are automatically placed to their correct reg's, without having to manually copy and paste one by one???
I have been told this is possible.
I have been told this is possible.
Answers
1 to 2 of 2
Best Answer
No best answer has yet been selected by spaced. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
Yip - use the VLOOKUP function.
In spreadsheet A, column C (next to your reg numbers and mileages) insert function VLOOKUP.
For Lookup Value it will be the first cell in column A containing a reg number.
For Table Array it will be the the range of your data in spreadsheet B.
For Column index number it will be the number of the column in spreadsheet B that contains the driver's names (A=1, B=2, etc)
For Range Lookup type in False to get an exact match.
Now copy the function down column C of spreadsheet A.
That should do the trick for you.
BW
In spreadsheet A, column C (next to your reg numbers and mileages) insert function VLOOKUP.
For Lookup Value it will be the first cell in column A containing a reg number.
For Table Array it will be the the range of your data in spreadsheet B.
For Column index number it will be the number of the column in spreadsheet B that contains the driver's names (A=1, B=2, etc)
For Range Lookup type in False to get an exact match.
Now copy the function down column C of spreadsheet A.
That should do the trick for you.
BW
1 to 2 of 2
