VLOOKUP duplicate values in table the table array? Help me solve

[chase5lewis]

So I am using VLOOKUP to extract data and often have duplicate values in
the table array. Now, I realize that VLOOKUP will only look at one row
with the reference value that you select. However, my problem is that I
will have multiple values in the table array that will refer to the same
reference point. Thus, I cannot extract the data set I need beyond the
first row... I need it to continue to pull the data from beneath row 1
matching my cust. id, reference point, and table array. I need help
adjusting this formula or need a new one all together. Looking forward
to your help guys.


A little more info:
I'm creating my own invoicing software for my company I run and I have
got everything figured out up unto this point. Please help me find a
solution to this problem.

I have attached the document containing the sheets you need so you can
see exactly what I mean. Please refer to the tab labeled invoice and
look in the description to find my problem. Thanks.


+-------------------------------------------------------------------+
|Filename: Vlookup Question.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=757|
+-------------------------------------------------------------------+



--
chase5lewis

[Kevin@Radstock]

Hi chase5lewis

If I understand you correctly! In B23 and copy down.
=IFERROR(INDEX(Figures!$C$7:$C$154,SMALL(IF(Figures!$A$7:$A$154=$J$10,IF(Figures!$K$7:$K$154=TRUE,ROW(Figures!$B$7:$B$154)-ROW(Figures!$B$6),"")),ROW(A1))),"")

This is an array formula and must be entered CTRL + SHIFT + ENTER, not
just enter.

Kevin

chase5lewis;1609287 Wrote:
> So I am using VLOOKUP to extract data and often have duplicate values in
> the table array. Now, I realize that VLOOKUP will only look at one row
> with the reference value that you select. However, my problem is that I
> will have multiple values in the table array that will refer to the same
> reference point. Thus, I cannot extract the data set I need beyond the
> first row... I need it to continue to pull the data from beneath row 1
> matching my cust. id, reference point, and table array. I need help
> adjusting this formula or need a new one all together. Looking forward
> to your help guys.
>
>
> A little more info:
> I'm creating my own invoicing software for my company I run and I have
> got everything figured out up unto this point. Please help me find a
> solution to this problem.
>
> I have attached the document containing the sheets you need so you can
> see exactly what I mean. Please refer to the tab labeled invoice and
> look in the description to find my problem. Thanks.


+-------------------------------------------------------------------+

+-------------------------------------------------------------------+



--
Kevin@Radstock