lookup function
 

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?

lookup function
 

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 wrote:
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?

lookup function
 

Thanks Aladin!


Aladin Akyurek wrote:
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 wrote:
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?