Excel query

[spaced]

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.

[Bushwhacker]

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

[spaced]

genius!!!!