VLOOKUP Table Assistance

Morning Folks,

I am currently working on the attached spreadsheet which calculates how many of the same Infringements a driver has committed within a 12 month period.

In my spreadsheet it will always be the same person driving the same car so I have entered these details on sheet 2 of my spreadsheet as i was using the data validation function to allow a drop down when entering the data.

I now however would like to have the drivers name auto populate into column C when I enter the registration number into column B so would I be correct in saying the way to do this would be to use a VLOOKUP Table?

Would any of you kind people be able to show me how I would implement a VLOOKUP Table in order to auto populate Column C upon Column B's entry or assist me with another way to do this?

Any help would be greatly appreciated!

Please see the spreadsheet that I am currently working with attached below.

Thanks in advance

Davie

Hi Davie,

Try this in cell C2 on Sheet1.

Please Login or Register  to view this content.

Hope this helps.

Snook

Hi Snook,

Thats superb! Im over the moon!

I cant thank you enough

Il mark this as resolved.

Have a great day and I hope I can assist you one day in the future

Davie

Can you please explain what was wrong with my title?

Thanks

My private message was in no way rude:

Please see my private message below:

Considering the query was resolved I didnt think it was a big deal to change the title on the post as you were on my case yesterday to mark my post as resolved so found this more important.

I think giving me a warning was rather pathetic however as long as its makes you feel important then I accept it.

Il make sure I title my posts more appropriatly next time even though I saw no issues with the way it was titled.

Appologies all the same tho.