lookup function

[unix-freak]

This function =LOOKUP(C2,$I$4:$I$89,$J$4:$J$89) is looking up text in
I4:I89 and rendering a number that is in the J column. If it doesn't
find anything, it seems to be doing a regular expression or something.
I need it to find an exact match or enter 0.00.

Any ideas?

 

[Aladin Akyurek]

If I:J sorted in ascending order on I...

=IF(LOOKUP(C2,$I$4:$I$89)=C2,LOOKUP(C2,$I$4:$I$89,$J$4:$J$89),"Not Found")

If I:J is not sorted...

=INDEX($J$4:$J$89,MATCH(C2,$I$4:$I$89,0))

 

[unix-freak]

Thanks Aladin!

If I:J sorted in ascending order on I...

=IF(LOOKUP(C2,$I$4:$I$89)=C2,LOOKUP(C2,$I$4:$I$89,$J$4:$J$89),"Not Found")

If I:J is not sorted...

=INDEX($J$4:$J$89,MATCH(C2,$I$4:$I$89,0))