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 i
the table array. Now, I realize that VLOOKUP will only look at one ro
with the reference value that you select. However, my problem is that
will have multiple values in the table array that will refer to the sam
reference point. Thus, I cannot extract the data set I need beyond th
first row... I need it to continue to pull the data from beneath row
matching my cust. id, reference point, and table array. I need hel
adjusting this formula or need a new one all together. Looking forwar
to your help guys.


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

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

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

 

[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, no
just enter.

Kevin

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


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

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

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