| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| large non contiguous data set | Charts and Charting in Excel | |||
| Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
| How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
| Conditional summing with large amounts of data | Excel Worksheet Functions | |||
| Bin and sort a large list of data | Excel Discussion (Misc queries) | |||
Threaded Mode
