Vlookup Differentation Risks
 

I'm using a vlookup function to draw data from a source sheet, into a
matrix report. We want to be able to review each service provider's
data.
If 2 different / unrelated service providers share the same reference
numbers, how can the vlookup function accuratley differentiate between
each provider's data?

How can this function be adjusted to capture data that is specifically
cooresponds to the right service provider?

Addie


--
addie
------------------------------------------------------------------------
addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
View this thread: http://www.excelforum.com/showthread...hreadid=389629

You would have to use either Sumproduct() or an Index() and Match()
combination, depending on the type of data (text - numbers) you're looking
to be returned.

Post back with the particulars of your data list configuration and data
types.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"addie" wrote in
message ...

I'm using a vlookup function to draw data from a source sheet, into a
matrix report. We want to be able to review each service provider's
data.
If 2 different / unrelated service providers share the same reference
numbers, how can the vlookup function accuratley differentiate between
each provider's data?

How can this function be adjusted to capture data that is specifically
cooresponds to the right service provider?

Addie


--
addie
------------------------------------------------------------------------
addie's Profile:
http://www.excelforum.com/member.php...o&userid=25526
View this thread: http://www.excelforum.com/showthread...hreadid=389629