| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Function help | Excel Discussion (Misc queries) | |||
| Lookup Function Problems | Excel Worksheet Functions | |||
| Complicated lookup function | Excel Worksheet Functions | |||
| lookup function 1 | Excel Worksheet Functions | |||
| How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
Linear Mode
