It gives me a #N/A result. And yes, I entered it as an array.



"T. Valko" wrote:

What does "it's not working mean" ?

Getting an error? Incorrect result?

If you have: This is correct.

A1 = Bob
B1 = Smith

And on sheet Addresses-Main Data Sheet:

Column A = first names
Column B = last names

That formula will work. Did you enter the formula as an array?

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

"Claudio Funes" wrote in message
...
It's not working.
And the information being pulled is alpha-numeric, and the names are
listed
only once.
Thanks for your help.

"T. Valko" wrote:

One way:

Try this array formula** :

=INDEX('Addresses-Main Data Sheet'!A1:K1000,MATCH(A1&B1,'Addresses-Main
Data
Sheet'!A1:A1000&'Addresses-Main Data Sheet'!B1:B1000,0),3)

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

If the data to be returned is numeric and the names (first last) are
listed
only once in the lookup sheet we can use a less complicated non-array
formula.

Biff

"Claudio Funes" wrote in message
...
I'm trying to read employee's records, and I have lots of Bobs and
others,
but different last names on the following column. The question is: how
do
I
make it read the next column to match the last name to extract the
information for that row? I can't just use the second column because
there
some same last names.

This is what I have right now, where $A1 is the first name, and
naturally
the last name is B1.

=VLOOKUP($A1,'Adresses-Main Data Sheet'!$A$1:$K$1000,3,0)

Thanks for your help.