Nested INDIRECT Command Not Populating Correctly

I don't see why you're using INDIRECT.

In your screencap those cells just contain numbers which I assume are supposed to be the column_index_num's.

See if this does what you want:

=N$4*VLOOKUP($B5,'BOM MATRIX'!$A$2:$AJ$500,N3,0)

Originally Posted by Tony Valko

I don't see why you're using INDIRECT.

In your screencap those cells just contain numbers which I assume are supposed to be the column_index_num's.

See if this does what you want:

=N$4*VLOOKUP($B5,'BOM MATRIX'!$A$2:$AJ$500,N3,0)

O_O that works! and yes it is the column_index_num's.

UPDATE: having trouble populating, jury's still out
UPDATE: Turns out I forgot to put $ for N3 :P

Good deal. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.