Need help matching two lists and importing data if match is found

[saber_cbm]

Hey all,

Hopefully someone on here can help me as I'm an Excel novice and really struggling to finish a task. I have two lists on a spreadsheet, Column A contains 300 user ids and column V contains 4,300.

I need a function that will search column V for the user id in column A and once it finds it, it will need to copy the username in column W into column D.

I really hope that makes sense and am grateful for any help given,

Kind regards,

Cristiaan

[Tony Valko]

Sounds like you want this...

=VLOOKUP(A2,V:W,2,0)

[saber_cbm]

Sounds like you want this...

=VLOOKUP(A2,V:W,2,0)

Hi Tony,

Thanks for the quick response. I have just tried that formula and I've got a #N/A

[Tony Valko]

#N/A means the formula can't find a match of A2 in column V.

Are you sure there's a match?

[saber_cbm]

#N/A means the formula can't find a match of A2 in column V.

Are you sure there's a match?

I figured it out, for some reason the IDs were stored as text, converted to number and it's picked them all up. Thanks so much for your help.

[Tony Valko]

Good deal. Thanks for the feedback!