Lookup Help Again

[andersonfvgn]

So, I have attached an example of what I want. But in a nutshell.

Sheet1 has 2 columns, several hundred rows long. Column A contains a region code (ie. AND/POY). Column B contains a point of contact.

Sheet2 has 2 columns, several hundred rows long. Column A contains a server name that contains a region code (ie. !AND/POY Production Server). Column B is blank.

I want a formula that will look at Sheet2, column A. It will then find the row in Sheet1 that contains the region code embedded in the Server Name and then fill in the B column with the point of contact name.

[tigeravatar]

Maybe...

Please Login or Register  to view this content.

[Harribone]

RegionLookup.xlsx

Attached should do what you want. Note that B4 has returned an error because the region in the server does not contain "/", I assume this is a typo but if there are any situations that this doesn't work for let me know.

EDIT: tiger's formula is tider than mine so use that one, looks like I've learnt something myself!

[andersonfvgn]

Thanks to both of you. Both formulas worked like a charm!