if a cell in one column contains a value of one cell, the return value in another cell

[cerickosn1011]

I have two sheets of data.

Sheet 1 contains
Column A = List of Parent Accounts
Column B = Parent IDs

Sheet 2 contains
Column A = Business Names
Column B = (currently blank) but I want to return the corresponding Parent ID

However, Parent accounts and not formatted the same as business names. Example a Parent account could read: "Parent: A Pea in the Pod" but the Business Name could read "Pea in the pod"

Can I create a formula that will look a given cell on sheet 2 in column A, then search for that text within column A on sheet 1, and return the value from sheet 1 column B when it finds that text? I have a feeling it's a mix of vlookup, IF, isnumber, search? But I can't quite figure it out.

Thanks for the help!

[PeteABC123]

Try this in sheet2 B2 and copy down:

Please Login or Register  to view this content.

Or, to trap the errors:

Please Login or Register  to view this content.

Pete

[cerickosn1011]

THANK YOU! Looks so easy now that I look at it, but I could NOT figure that out. Thank you so much for saving me HOURSSS!