Isna/index/match

[MBCMDR]

Hello,



BELOW CODE INDEX/MATCH HAS TWO CRITERIA WHEN LOOK UP ON MY .xlsb that an active SQL

So the below CODE populates and creates a matrix in CELLS G5:AA205 from the .xlsb lookups


I have a excel sheet that is broken down into columns/row. Row 2 is (B#)build numbers 1,2,3,4,5,6,7,8 ETC

Please Login or Register  to view this content.

On that same sheet Column B list all the possible configuration of parts used, each build is per custom order.

Please Login or Register  to view this content.

Because I used ISNA it double the size in code below but keeps those nasty #N/A out of my sheet..

Please Login or Register  to view this content.

Here is my problem the code populates fine from the .xlsb looking up B#1 but when I look up the next B#2 on the .xlsb it populates B#2 and erases B#1 data off my spreadsheet. I want to retain the previous B# look up and only replace if and when I look it up again.


Regards,
MBCMDR

[MBCMDR]

HERE IS A MINI SAMPLE

Because did all in one file here it works fine but in fact my SHT Full JOB List is another file that shows only one build per look up, when lookup second build it erases the first lookup of build 1.

Just trying to give you more detail..

So if you renumber the cell G6:G10 too B#2 from B#1 you see how all the B#1 is erased on the MASTER while I like to keep all that info.

MBCMDR