Formula returning wrong column

[ExcelRoy]

Hi all,

i have the following formula

=IFERROR(LOOKUP(2,1/(($BJ$3:$BJ$5002=C5)*($BK$3:$BK$5002=I5)),BO5),"")

Which should return the contents of BO5 but infact returns BR5 ?

Any ideas why this would be?

It works fine if used on row 3,4 etc

Thanks for any help

 

[Aladin Akyurek]

Re: Formula returnign wrong column

Your intent is not clear...

Are you looking for the result of the following?

=IFERROR(LOOKUP(9.99999999999999E+307,1/(($BJ$3:$BJ$5002=C5)*($BK$3:$BK$5002=I5)),$BO$3:$BO$5002),"")​

 

[ExcelRoy]

Re: Formula returnign wrong column

Perfect thanks Aladin

 

[Aladin Akyurek]

Re: Formula returnign wrong column

Perfect thanks Aladin

You are welcome.