Linked text from another sheet if a certain text exists

I placed the formula in the example below.

It's an Index Match Match, it looks at the value you enter and the column headers.

Formula:

Please Login or Register  to view this content.

Ferdy

Thank you. I was able to get thigs to work, but I will have to separate the "linked Sheet" and make it its own workbook. I now have two workbooks with renamed sheets.
The master being "Yokota Leadership with Spouses". The other one that needs the linking is "Yokota Leadership with Spouses for distro"


Given this new development, what would my formula look like now? I tried to point it to the new workbook/sheet, but I kept getting an error. Additionally, is there a way without the use of macros to make the new workbook automatically update when it opens?

In addition, when the word "Spouse" appears in column "E", I would like the first name to populate in column "E" on Yokota Leadership with Spouses for distro.

Hey there,

Sorry for the late response, but i'm usually not on here on the weekends.

Pretty much the only change that has to be made to the old formula is a reference to the workbook.

Formula:

Please Login or Register  to view this content.

Place in B6, drag across to D6 and then down.

For the Spouse formula you can use the following.

Formula:

Please Login or Register  to view this content.

Place in E6 and drag down.

Note that these will only work if "Yokota Leadership with Spouses.xlsx" is open

Not entirely sure with automatically update when opened. If this is about getting the data required to make the formula's work without having the other workbook open, i'm afraid that I don't know of a way of doing this without coding.

Ferdy