Help - linking and/or formulas.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nyreddbone - 16 Sep 2007 20:40 GMT

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.

Reply to this Message

Per Erik Midtrød - 16 Sep 2007 21:34 GMT

On Sep 16, 9:40 pm, nyreddbone <nyreddb...@discussions.microsoft.com>
wrote:

> Hi,
>
[quoted text clipped - 10 lines]
> I hope I've asked the right questions. Any help would be appreciated, I had
> no idea it would be so challenging.

I suggest you look at the vlookup formula.
Say you have vendor ID in column A on sheet1 and want to get the
information from column B, your formula would look something like
this:
=VLOOKUP("Vendor ID";Sheet1!A:B;2;FALSE)

Obviously you would replace "Vendor ID" with a cell reference.

Per Erik

Per Erik

Reply to this Message