Excel Formula Help

Soldato
Joined
27 Mar 2004
Posts
14,081
Location
Between Realities
I am wanting to compare 2 worksheets and give the data in a cell as a result.

We use numbers as logins on site. I have 2 work sheets, 1 worksheet has all 5000 usernames and the full name of the person(Which I will be hiding)

I want to compare worksheet 1 which is usernames and the last time they made a transaction, And put the full name into worksheet 1 next to the corresponding username.

Any help out there?
 
Errrm. Yeah when I read it back it looked hard to digest.

I'll break it down:-

Worksheet 1:
A = Username
B = Time of pick
C = This will be where the formula goes

Worksheet 2:
A = Username
B = Fullname

Worksheet 2 has 5000 names, not all of which will be on worksheet 1. So it needs to look at the column, match the relevant username, and output the full name into Worksheet 1, Cell C.

:)
 
Thanks for this!! I used:-

=VLOOKUP(A3,Worksheet2!A$2:B$5000,2,FALSE)

And it worked great once i made a few amendments! Would have posted thanks earlier, but IT working for an E retailer warehouse, Leading up to christmas....

:D
 
Back
Top Bottom