Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find a alphanumeric in a list
I have a column in which there are alphanumerical in cell B10 to B20 (red 3,
red4, red6, red9, red10, red 15, red17, red18, red20, red23). I have cell in which the input has given say cell A10 (red5) & I have a cell which will tell whether input in A10 is present from the B10 to B20 or not say cell S10. If Im putting the logic statement in cell S10 the logic should results in €śfalse€ť or €śtrue€ť. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find a alphanumeric in a list
No need to start another thread - check your previous thread.
Another approach is to use MATCH: =ISNUMBER(MATCH(A10,B10:B20,0)) but you must be more consistent with your data, as you are looking for exact matches. Hope this helps. Pete On Jan 5, 9:41*am, 2226 wrote: I have a column in which there are alphanumerical in cell B10 to B20 (red 3, red4, red6, red9, red10, red 15, red17, red18, red20, red23). I have cell in which the input has given say cell A10 (red5) & I have a cell which will tell whether input in A10 is present from the B10 to B20 or not say cell S10. If I’m putting the logic statement in cell S10 the logic should results in “false” or “true”. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find a alphanumeric in a list
Please check whether the below mentioned formula is ok for u
In C:10 to C:19 type the value as true. =IF(A10="","",VLOOKUP(A10,B10:C19,2,"FALSE")) Byee. Shaun "2226" wrote: I have a column in which there are alphanumerical in cell B10 to B20 (red 3, red4, red6, red9, red10, red 15, red17, red18, red20, red23). I have cell in which the input has given say cell A10 (red5) & I have a cell which will tell whether input in A10 is present from the B10 to B20 or not say cell S10. If Im putting the logic statement in cell S10 the logic should results in €śfalse€ť or €śtrue€ť. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to find 'n'th largest alphanumeric field (like "Large") | Excel Worksheet Functions | |||
Making long alphanumeric list | Excel Discussion (Misc queries) | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
sorting an alphanumeric list - please someone help! | Excel Discussion (Misc queries) |