Improved Formula / i've run out room to extend the current formula / (avdanced code needed

Hello All

RE: i've posted this on the formula section as well, I've been advised that CODE maybe the solution

I'm told the current formula in C6 is the only solution to my current problem,

I've pasted this repeatedly to capture more columns, (by moving the little colored boxes into the correct column) the formula does work and the sheet is almost doing exactly what i want it to do

IF($A6<>"",INDEX($Z:$AE,MATCH(BC$5,$CX:$CX,0),MATCH(C$5,$Z$5:$AE$5,0))(INDEX($AK:$CW,MATCH($A6,$AH:$AH,0),MATCH(INDEX($CX:$CX,MATCH(BC$5,$CX:$CX,0)),$AK$5:$CW$5,0))))

My BIG problem, there are 37 columns that i cant add to C6 formula starting at BM i need to add these columns to the current formula some how,

can this be replicated via a code (please note there is only a formula in column c ..... the same formula will need to be copied to D,E,F,G

Paul

LOL!!!

I'm trying to use excel to work out components required to build a lock set,

Column A is looking at a (built up lockset part number) row 5, then it looks up the components required to build that particular lockets....

component list is in column A, the values come from the table to the far right

As OP notes this is posted here also: https://www.excelforum.com/excel-for...t-formula.html

I've posted a suggested "simplification". Would ask you close either / or Thread, per Forum Rules...