Prev: Summary worksheet within a workbook
Next: Summarize a range referenced in a separate worksheet
From: pawcoyote on 23 Mar 2010 15:10
Greetings,

Here is what I am trying to do... *NOVICE Here*

I have a workbook that has multiple spreadsheets with various data on them.
I want to "Match" Data in one column A on spreadsheet 1 to column B in
spreadsheet 2 and then fill data from column C on spreadsheet 1 to column D
on spreadsheet 2 if Column A & B match...

I am having a dickens of a time trying to do this... Any help is much
apprecaited.
--
--Coyote--
From: Luke M on 23 Mar 2010 15:50
In D1 of sheet 2:
=IF(ISNUMBER(MATCH(B1,'Sheet 1'!A:A,0),VLOOKUP(B1,'Sheet 1'!A:C,3,),"")

--
Best Regards,

Luke M
"pawcoyote" <pawcoyote(a)discussions.microsoft.com> wrote in message
news:6BF4BC29-81EA-41D9-A544-026F1A4D76AF(a)microsoft.com...
> Greetings,
>
> Here is what I am trying to do... *NOVICE Here*
>
> I have a workbook that has multiple spreadsheets with various data on
> them.
> I want to "Match" Data in one column A on spreadsheet 1 to column B in
> spreadsheet 2 and then fill data from column C on spreadsheet 1 to column
> D
> on spreadsheet 2 if Column A & B match...
>
> I am having a dickens of a time trying to do this... Any help is much
> apprecaited.
> --
> --Coyote--


 | 
Pages: 1
Prev: Summary worksheet within a workbook
Next: Summarize a range referenced in a separate worksheet