Hi,
I assume that
TechUser ID in in sheet2 column B, and you want the result from column A
LeadID is in sheet 1 in column A starting row 1

In cell B1 sheet 1 enter

=sumproduct(--(A1=Sheet2!$B$1:$B$100),sheet2!$A$1:$A$100)
Change sheet name and range to fit your needs but remember that the range
has to be the same in both parts of the formula


"TraciAnn via OfficeKB.com" wrote:

Hello!

I use range names for all my functions and I'm trying to lookup a number
(LeadID) in a column (TechUserID) on another sheet (same workbook) and return
the value one column to the left (TechFullName).

I am using:
=INDEX(TechFullName,MATCH(LeadID,TechUserID,0),1)

But it is returning an "#N/A"

The sort order of the sheet varies so I'm not sure if that has an impact in
'07 like it did in previous versions, but I know it doesn't matter with
VLOOKUP any more.

Am I using the right function?

--
---
TraciAnn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200905/1