Hello,

I'm trying to look-up and match 3 fields from two separate sheets from a
range of information. For example, in my sheet I will enter information such
as
Name, Age, BirthMonth and I want to have a formula that will returned
another field called Status by performing a lookup from my source file.

What formulas do I have to use to obtain what I'm looking for?

Thank you,
Nelson

Hi!

Need more detail!

Where are the "fields"? Where is the data you want to return?

Detail! Be specific.

Biff

"Nelson" wrote in message
...
Hello,

I'm trying to look-up and match 3 fields from two separate sheets from a
range of information. For example, in my sheet I will enter information
such
as
Name, Age, BirthMonth and I want to have a formula that will returned
another field called Status by performing a lookup from my source file.

What formulas do I have to use to obtain what I'm looking for?

Thank you,
Nelson

The data is in a separate file containing the same 3 fields plus additional
fields that I want to bring the information into my file. The data file is
organized by collumns such as:
1st collumn=Name
2nd collumn=Age
3rd collumn=BirthMonth
4th collumn=Status
5th collumn=Grade
etc...

My second file, I will have the same collumns but I want to enter the
information in the first 3 collumns and then I want my formula to match them
to the data file and return the 4th collumn
So, I want it to look at the 3 fields that I entered and look into the data
file and give me the status or Grade of that individual that i just entered.
Just like a Vlookup, but instead of just looking at the left-most collumn, I
want it to look at 3 collumns and match the 3 collumns on the data file and
return a value.

I hope that will be a bit more clear!

Thank you for replying



"Biff" wrote:

Hi!

Need more detail!

Where are the "fields"? Where is the data you want to return?

Detail! Be specific.

Biff

"Nelson" wrote in message
...
Hello,

I'm trying to look-up and match 3 fields from two separate sheets from a
range of information. For example, in my sheet I will enter information
such
as
Name, Age, BirthMonth and I want to have a formula that will returned
another field called Status by performing a lookup from my source file.

What formulas do I have to use to obtain what I'm looking for?

Thank you,
Nelson

Hi!

So, if you have 2 different xls files...

Here's the basic formula.

=INDEX('C:\PATH\[Data.xls]Sheet1'!$D$2:$D$5,MATCH(1,('C:\PATH\[Data.xls]Sheet1'!$A$2:$A$5=A2)*('C:\PATH\[Data.xls]Sheet1'!$B$2:$B$5=B2)*('C:\PATH\[Data.xls]Sheet1'!$C$2:$C$5=C2),0))

If the Data file will be closed then you have to include the path to the
file. The best way to do this so you don't have to type all that stuff in is
to have the other workbook open and as you "write" the formula you just use
your mouse to point to the locations and Excel will automatically add all
the references.

So, if in your second file on the sheet where you want this formula you
have:

Column A = Name
Column B = Age
Column C = Status

With data in row 2 on down.....

Enter this formula in D2 as an array using the key combo of
CTRL,SHIFT,ENTER:

Here's the same formula without the path: (should be a little easier to
read)

=INDEX([Data.xls]Sheet1!$D$2:$D$5,MATCH(1,([Data.xls]Sheet1!$A$2:$A$5=A2)*([Data.xls]Sheet1!$B$2:$B$5=B2)*([Data.xls]Sheet1!$C$2:$C$5=C2),0))

In my example I'm using Data.xls Sheet1 as being where the data to return is
located.

Biff

"Nelson" wrote in message
...
The data is in a separate file containing the same 3 fields plus
additional
fields that I want to bring the information into my file. The data file
is
organized by collumns such as:
1st collumn=Name
2nd collumn=Age
3rd collumn=BirthMonth
4th collumn=Status
5th collumn=Grade
etc...

My second file, I will have the same collumns but I want to enter the
information in the first 3 collumns and then I want my formula to match
them
to the data file and return the 4th collumn
So, I want it to look at the 3 fields that I entered and look into the
data
file and give me the status or Grade of that individual that i just
entered.
Just like a Vlookup, but instead of just looking at the left-most collumn,
I
want it to look at 3 collumns and match the 3 collumns on the data file
and
return a value.

I hope that will be a bit more clear!

Thank you for replying



"Biff" wrote:

Hi!

Need more detail!

Where are the "fields"? Where is the data you want to return?

Detail! Be specific.

Biff

"Nelson" wrote in message
...
Hello,

I'm trying to look-up and match 3 fields from two separate sheets from
a
range of information. For example, in my sheet I will enter
information
such
as
Name, Age, BirthMonth and I want to have a formula that will returned
another field called Status by performing a lookup from my source file.

What formulas do I have to use to obtain what I'm looking for?

Thank you,
Nelson