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