Excel Formula Help

wannabedamned · 4 Dec 2014 at 22:07

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?

gpuerrilla · 4 Dec 2014 at 23:10

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.

Grrrrr · 4 Dec 2014 at 23:19

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?

wannabedamned · 5 Dec 2014 at 02:03

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.

moogle · 5 Dec 2014 at 03:04

wannabedamned said:
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

Lartyconshayo · 5 Dec 2014 at 05:26

Alternate option

http://www.randomwok.com/excel/how-to-use-index-match/

wannabedamned · 8 Dec 2014 at 07:06

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

moogle · 10 Dec 2014 at 11:31

You're welcome!