I need a formula to reference an external workbook for to query a cell range for a certain entry to exist, and if that specific text is present, it will cross reference the a cell from a certain column in the same row and check if it is present in a column of the source sheet – if it does, it can populate with “Present”, and if it does not, populates with “Needs Added”.
In these example workbooks, I would like “Example Spreadsheet” Column B to house this formula. The Formulas will reference “Example Spreadsheet 2” cell range
$A$2:$A for “Larry’s”, where “Larry’s” is present, it will compare cell range
$D$2:$D in “Example Spreadsheet 2” to
$C$2:$C in “Example Spreadsheet”. If present in both, it will populate with “Present” and if the store number is missing from
$D$2:$D, it will populate with “Needs Added”.
The Links to the Example Spreadsheets are: