Multiple Look Up Results

[chaysp81]

Hello, I am trying to run a front page for my staff that when they enter a part number it gives them eta's of parts.

however I am only familiar with Vlookups and I don't think I can get multiple returns with this function.

I have attached the example, if I enter a part number in Cell C3 I would like the Rectangle Area to display the results that are on the data tab.

Any help would be greatly appreciated.

[NBVC]

In the Data sheet, in Q2 enter formula:

=IF(E2='Look Up'!$C$3,COUNT($Q$1:$Q1)+1,"")

copied down

Then in the Lookup sheet, in C7 enter:

=IFERROR(INDEX(Data!$P:$P,MATCH(ROWS($C$7:$C7),Data!$Q:$Q,0)),"")

copied down (format to date).

same formula in D7 and E7, adjusting the INDEX'd range to appropriate column for Invoice Number and Qty.