It gave me an error (formular contains errors)

Hmmm...

There's nothing wrong with the formula. Did you enter it as an array?

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


--
Biff
Microsoft Excel MVP


"Seantastic" wrote in message
...
It gave me an error (formular contains errors)

"T. Valko" wrote:

Try this array formula** :

=INDEX(Inventory!A$2:A$8729,MATCH(1,(Inventory!I$2 :I$8729=B2)*(Inventory!J$2:J$8729=C2),0))

Copy down as needed

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

--
Biff
Microsoft Excel MVP


"Seantastic" wrote in message
...
I have a spreadsheet with 2 tabs.

First tab is named "inventory" and has a list of "computer names" in
column
"A" (from row 2 to 8729) the user "First Name" in column "I" and the
users
"Last Name" in column "J".
There is no particular order in this list and the names are in some
random
order.

My second tab is named "Users" and has a list of the user "First Name"
in
column "B" and the users "Last Name" in column "C". Column "A" is
blank.
There is no particular order in this list and the names are in random
order.

I want excel to take the First Name and Last Name that are in the
"Users"
tab look it up (match) the Same First and Last Name in the "inventory"
and
copy the associate "computer name" from Column "A" back into the blank
column
"A" of my "Users" tab.

I tried this functions =VLOOKUP(C2;Inventory!J2:K8729;2)
but the problem I got was
1) It only looked at Last Names (and I have a few Smiths)
2) When it encountered blank spaces in tab "inventory" in would not
continue
lower
3) Did not go through all the list in tab "inventory"
4) Did not work - I do not really know what I am doing!!
vvvv