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?
 
Tough one to digest but I get what you mean. Something is telling my head to use the copy -> paste (option as link cells).

However the logical exception in me is import the data into access to achieve the same thing then just export it to a new sheet.
 
I'm not sure I understand what you want to achieve. Can you upload am example of what you've got and what you need?
 
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.

:)
 
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.

:)

Worksheet 1: Cell C Formula =VLOOKUP(A,Worksheet2!A$2:B$5000,2,FALSE)

So if you're putting that formula in C3 then the formula would be =VLOOKUP(A3,Worksheet2!A$2:B$5000,2,FALSE)

You've got to drag the formula down to all the other cells in C where you want it to fill stuff in.

HTH
 
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