Hi,

I need help. I am working in a spreadsheet that has a list of ALL of the
providers that I work with. I need to get information/link information from
another worksheet that has a FEW of the providers on the worksheet.

1. If I link these documents, does Excel automatically recognize the fact
that not all providers are listed or do I need to create a formula for that?
2.If I need to create a formula I think it should start with IF, but I'm not
sure where to go after that
3. If a formula is needed, do I have to link the formulas?

I hope I've asked the right questions. Any help would be appreciated, I had
no idea it would be so challenging.