Conditional Help

[OfficeGeek]

After reading through the forums here, it seems like this is where I can find some help. Apologies in advance for the laymen terms.

Example of my Issue:
Worksheet 1

Column A : Column B
email addy account#
​

Worksheet 2

Column A : Column B
email addy create value
​

Worksheet 1 has a list of 500 emails with accounts
Worksheet 2 has a list of 250 emails
*considering the mismatch of rows the emails will not match in each worksheet

I am looking to see if it is possible to create a formula to look for a text match between Sheet1!A:A and Sheet2!A:A AND if so copy the Account # from Sheet 1 for that corresponding match to Sheet 2 Column B

While I am not very experienced with excel formulas, I believe the logic is there, just need a bit of help to figure out how to tell excel that

Any help would be greatly appreciated.

 

[kkfighter]

Hi OfficeGeek,

A simple vlookup should be able to meet your requirement.

At worksheet column2, just do a =vlookup(A2,'worksheet 1'!A:B,2,0)

If you are using old version of excel use this =vlookup(A2,'worksheet 1'!A1:B501,2,0) as old version of excel do not read A:B

Smile,
KK

 

[OfficeGeek]

KK,

Thanks a bunch. The vlookup feature works like a charm.

-geek