Ask Formula - Vlookup, sort, different sheet + more colomns

Hi

I have asked for a formula in another thread and it was answered very nicely (here : https://www.excelforum.com/for-other...ml#post5711860).

But problem with the formula is that, I will be needing to add more and more numerical colomns. So my question regarding the given formula below is :
=INDEX(Sheet2!A:A,-MOD(LARGE((Sheet2!$B$1:$C$1=$A2)*Sheet2!$B$2:$C$10*10000-ROW($2:$10),COUNTIF($A$2:$A2,$A2)),-1000))

- If it is notably as $B$1:$C$1 and $B$2:$C$10, then how is the formula will looks like if I adds more colomn (sheet2 - colomn D) and more rows (sheet2 - A11:D18)?

I may needed the rows to be infinite actually.

Refers here :
https://www.excelforum.com/for-other...ml#post5711860

The sheet is here :
https://docs.google.com/spreadsheets...IOo/edit#gid=0

Thank you

@wk9128

Upload the attachment in question and attach the expected result you want, thank you

worksheet or Tab name : Sheet1

Cell B2 array formula , Drag down (Attachments are filled with yellow)

Formula:

Please Login or Register  to view this content.

Hi,

Thank you but there's a misunderstanding. In sheet2, We should not be targeting column H:L but we should be targeting A:D. Because H:L is just an illustration for you to gain a better understanding.

Keep everything in THIS thread going forward, please. There is little difference between the multiple threads you have running and it is all getting very confusuing. If you are referring back to previous threads, then you should not be opening new ones!

I have copied the post from your closed thread here (see post #5).

Please stop reporting my posts and continue here. Thank you.