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!