Home |
Search |
Today's Posts |
#1
|
|||
|
|||
find partial values in cell
I there a way to look in one column with values like 6292, 266, 3885, 96,
47... then compare the last two digits from a cell with those in an array? Example: C K L 6292 00 18 266 11 28 3888 22 38 96 33 48 48 44 58 9 55 68 5565 66 78 2978 77 98 88 99 I need to lookup last part of a cell (ie, looking in col. "C" at 3888 and match last two digits/values 38(88) with col's "K" and "L" or any array for that matter. Does that make sense? There is the issue of single digit values like "9" that may mess with me but there are very few of those and they can be over looked. Thank you for your time Luke |
#2
|
|||
|
|||
Your problem description is a bit underspecified... Given what is provided:
=ISNUMBER(MATCH(RIGHT(C2,2)+0,$K$2:$K$10,0))+ if the items in K2:K10 are numbers. Otherwise: =ISNUMBER(MATCH(RIGHT(C2,2),$K$2:$K$10,0))+0 Regarding the single digit cases... =ISNUMBER(MATCH(RIGHT("0"&C2,2),$K2:$K&10,0))+0 assuming that K2:K10 does not house true numbers. Luke wrote: I there a way to look in one column with values like 6292, 266, 3885, 96, 47... then compare the last two digits from a cell with those in an array? Example: C K L 6292 00 18 266 11 28 3888 22 38 96 33 48 48 44 58 9 55 68 5565 66 78 2978 77 98 88 99 I need to lookup last part of a cell (ie, looking in col. "C" at 3888 and match last two digits/values 38(88) with col's "K" and "L" or any array for that matter. Does that make sense? There is the issue of single digit values like "9" that may mess with me but there are very few of those and they can be over looked. Thank you for your time Luke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refreshing drop down cell values... | Excel Worksheet Functions | |||
Update of cell values after insert row? | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Find the cell value in excel by using vb code | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions |