Matching Files on Different Worksheets

[JoeL]

Help!

I have 1 master spreadsheet with all files and 2 seperate worksheets
(labeled NVS and FSV). I need to find out how to indicate if the file on the
master worksheet is also located on the NVS or the FSV spreadsheet (though,
it may not be on either).

Essentially, if the file on the master is located on NVS or FSV or Neither,
then I need to indicate that on the master file (new column). So, it needs to
look something like this:

File # File Name NVS or FSV
ABC123 Blah NVS
ABC124 Clat FSV
ABC125 Dlad Neither

Please help and let me know if you need additional information.

Thank you!

 

[smartin]

Help!

I have 1 master spreadsheet with all files and 2 seperate worksheets
(labeled NVS and FSV). I need to find out how to indicate if the file on the
master worksheet is also located on the NVS or the FSV spreadsheet (though,
it may not be on either).

Essentially, if the file on the master is located on NVS or FSV or Neither,
then I need to indicate that on the master file (new column). So, it needs to
look something like this:

File # File Name NVS or FSV
ABC123 Blah NVS
ABC124 Clat FSV
ABC125 Dlad Neither

Please help and let me know if you need additional information.

Thank you!

For simplicity, add a couple helper columns, let's say in columns Y and
Z. Y does lookup to NVS, Z does lookup to FSV. You will either get
matching values or #N/A in these columns. The final result can be built
up with this (unchecked) formula:

=IF(AND(ISNA(Y),ISNA(Z)),"Neither",IF(ISNA(Y),"FSV","NVS"))

You did not suggest the file could exist in both, and this formula
wouldn't work properly if so.