Returning a value if data is in a large list
I think you use a IF function but I am not sure.
I have two large lists of numbers. The lists are in columns A and C with columns B and D blank. In B, I want to insert an "X" if the number in column A next to it is somewhere in column C. I tried =IF(A2=C:C,"X","") and =IF(A2=C2;C1000,"X","") but they do not work. Is there a way I can do this? |
One way:
=IF(COUNTIF(C:C,A1)0,"x","") Another way: =IF(ISNUMBER(MATCH(A1,C:C,0)),"x","") I like the second way. It'll be faster for larger lists in column C. ChrisRad wrote: I think you use a IF function but I am not sure. I have two large lists of numbers. The lists are in columns A and C with columns B and D blank. In B, I want to insert an "X" if the number in column A next to it is somewhere in column C. I tried =IF(A2=C:C,"X","") and =IF(A2=C2;C1000,"X","") but they do not work. Is there a way I can do this? -- Dave Peterson |
=IF(ISNA(MATCH(B4,D4:D8)),"","X") is, I think, what you want. Gaz -- gazornenplat ------------------------------------------------------------------------ gazornenplat's Profile: http://www.excelforum.com/member.php...o&userid=24494 View this thread: http://www.excelforum.com/showthread...hreadid=380928 |
All times are GMT +1. The time now is 04:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com