• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF Match between different sheets

M

Matt Jacobs

New Member
I am trying to write a formula that will take information from one sheet and plug it into a different sheet if it sees that the text in column A matches.

I have a lot of different list companies and contact emails for those companies for different trade shows. There is a lot of over lap and just looking back through the info is very time consuming.

I want to write a function that says:

IF there is a Match between Sheet1A1 and Sheet2A:A(All of column A in sheet 2) then insert Sheet2B from the row in Sheet2 that matched Sheet1A1.

I have tried a bunch of different stuff and it wont work. What I have so far is IF(Match(Sheet1A1,Sheet2A:A,0),Sheet2B:B,"").

It isn't working. Any help would be greatly appreciated.

Thank You.

Matt
 
Matt Jacobs said:
I am trying to write a formula that will take information from one sheet and plug it into a different sheet if it sees that the text in column A matches.

I have a lot of different list companies and contact emails for those companies for different trade shows. There is a lot of over lap and just looking back through the info is very time consuming.

I want to write a function that says:

IF there is a Match between Sheet1A1 and Sheet2A:A(All of column A in sheet 2) then insert Sheet2B from the row in Sheet2 that matched Sheet1A1.

I have tried a bunch of different stuff and it wont work. What I have so far is IF(Match(Sheet1A1,Sheet2A:A,0),Sheet2B:B,"").

It isn't working. Any help would be greatly appreciated.

Thank You.

Matt
Click to expand...
Hi,

Try it like this.

=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

or to hide the error if there's no match

=IFERROR(VLOOKUP(A1,Sheet2!A:B,2,FALSE),"")

or if you want it on another worksheet.

=IFERROR(VLOOKUP(Sheet1!A1,Sheet2!A:B,2,FALSE),"")
 
Mike H.. said:
Hi,

Try it like this.

=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

or to hide the error if there's no match

=IFERROR(VLOOKUP(A1,Sheet2!A:B,2,FALSE),"")

or if you want it on another worksheet.

=IFERROR(VLOOKUP(Sheet1!A1,Sheet2!A:B,2,FALSE),"")
Click to expand...

YES! thank you!
 
You must log in or register to reply here.
Back
Top