Thread: lookup function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
unix-freak
 
Posts: n/a
Default 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?