lookup function

U

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?
 
A

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))
 
U

unix-freak

Thanks Aladin!


Aladin said:
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))
Click to expand...
 
Top