lookup function

  • Thread starter Thread starter unix-freak
  • Start date Start date
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?
 
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))
 
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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top