additional help needed on multi retrieve formula

[deancorleone]

Hi

I am hoping someone can help build on kvsrinivasamurthy's formula in the attached worksheet.

The initial formula built pulls info from the same tab, in the attached workbook I am seeking a formula that is input in the Tab entitled Recon sourcing from the data tab.

I made an addition to my first question by concatenating so as to return the 3 variables in 1 cell, is the possibility for concatenating limitless?

Thanks all again!

[Pepe Le Mokko]

I think the CONCATENATE function is limited to 255 arguments in post 2003 versions of XL
If you need more instead of the function you can use the & like =A1&A2&A3
This could limit you to the number of characters the cell will accept for a formula (8192 in XL2007)

[deancorleone]

Good to know an additional workaround for concatenate!

Anyone have any idea about adapting that formula =CONCATENATE(IFERROR(INDIRECT("a"&SMALL(IF($D$2:$D$29<>$J$2:$J$29,ROW($J$2:$J$29),""),ROW(A1))),"")," ",(IFERROR(INDIRECT("B"&SMALL(IF($D$2:$D$29<>$J$2:$J$29,ROW($J$2:$J$29),""),ROW(B1))),"")))

to allow it to search from Cell D4 in the Recon tab sourcing the data from the data tab?

Thanks again!
Dean