| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statements
I need help with an if statement. I have two seperate columns that I need to compare. I need to compare each value in one column to all the values in the other column to see if I have any that match. What should my formula look like? For instance I'm comparing column B with column Q and using the following formula but it is not working. =if(or(B1=$Q$1:$Q$150),"Yes","") Any help will be greatly appreciated. -- tdoughty ------------------------------------------------------------------------ tdoughty's Profile: http://www.excelforum.com/member.php...o&userid=29616 View this thread: http://www.excelforum.com/showthread...hreadid=493180 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statements
You could use a MATCH function to see if b1 is anywhere in Q1:Q150:
=if(isna(match(b1,$Q$1:$Q$150,false)),"","Yes") "tdoughty" wrote: I need help with an if statement. I have two seperate columns that I need to compare. I need to compare each value in one column to all the values in the other column to see if I have any that match. What should my formula look like? For instance I'm comparing column B with column Q and using the following formula but it is not working. =if(or(B1=$Q$1:$Q$150),"Yes","") Any help will be greatly appreciated. -- tdoughty ------------------------------------------------------------------------ tdoughty's Profile: http://www.excelforum.com/member.php...o&userid=29616 View this thread: http://www.excelforum.com/showthread...hreadid=493180 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statements
That worked. Thank you very much. -- tdoughty ------------------------------------------------------------------------ tdoughty's Profile: http://www.excelforum.com/member.php...o&userid=29616 View this thread: http://www.excelforum.com/showthread...hreadid=493180 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "IF Statements in Microsoft Excel | Excel Discussion (Misc queries) | |||
| How do I sum percentages calculated from IF statements? | Excel Worksheet Functions | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
| If statements | Excel Worksheet Functions | |||
Hybrid Mode
