Hi chase5lewis
If I understand you correctly! In B23 and copy down.
=IFERROR(INDEX(Figures!$C$7:$C$154,SMALL(IF(Figure s!$A$7:$A$154=$J$10,IF(Figures!$K$7:$K$154=TRUE,RO W(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
Quote:
Originally Posted by 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.
|