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

(G2=    H2, I2, J2 ETC

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

(B5      B6, B7, B8, ETC

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

//COLUMN G ROW 5
=IF(ISNA(INDEX('[MFG SOI List.xlsb]Full Job List'!$U$6:$U$5000,MATCH(B5,IF(G2='[MFG SOI List.xlsb]Full Job List'!G6,'[MFG SOI List.xlsb]Full Job List'!$H$6:$H$5000),0))),
 "",INDEX('[MFG SOI List.xlsb]Full Job List'!$U$6:$U$5000,MATCH(B5,IF(G2='[MFG SOI List.xlsb]Full Job List'!G6,'[MFG SOI List.xlsb]Full Job List'!$H$6:$H$5000),0)))

//COLUMN H ROW 5
=IF(ISNA(INDEX('[MFG SOI List.xlsb]Full Job List'!$U$6:$U$5000,MATCH(B5,IF(H2='[MFG SOI List.xlsb]Full Job List'!G6,'[MFG SOI List.xlsb]Full Job List'!$H$6:$H$5000),0))),
 "",INDEX('[MFG SOI List.xlsb]Full Job List'!$U$6:$U$5000,MATCH(B5,IF(H2='[MFG SOI List.xlsb]Full Job List'!G6,'[MFG SOI List.xlsb]Full Job List'!$H$6:$H$5000),0)))

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