Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Vlookup with validation | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |