If the formula is in a cell on Form 1001x RV1, you don't want to include that in

your formula:

=INDEX('Utility base'!$D$3:$D$800,

MATCH(1,Q5='Utility base'!$A$3:$A$800)

*(Q6='Utility base'!$B$3:$B$800),0)

If you really did the array formula and you got #n/a, then what you think are

matches aren't really matches.

Maybe you have extra spaces in one of the cells (Q5 or A99 (say)). Or maybe

your numeric data isn't really a number in one of the cells (text vs number).

Try to eyeball the the matching row (say it's 99).

Then put

=q5='utility base'!A99

and

=q6='utility base'!b99

in a couple of empty cells.

You'll see at least one false. You'll have to fix those differences.

(Or modify the formula to take those differences into consideration.)

SMOKN_ENG_MOM said:

Yes on the array and yes on the entry matches.

Yes it is pretty simple first column numbers second alphabet... thrid

column text title.

=INDEX('Utility base'!$D$3:$D$800,MATCH(1,'FORM 1001X RV 1'!Q5='Utility

base'!$A$3:$A$800)*('FORM 1001X RV 1'!Q6='Utility base'!$B$3:$B$800),0)

Question should i remove the title of the sheet it is actually on? (FORM

1001x RV1??