| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two columns and return a third
I'm having some trouble. I'd like to compare two columns and return data
from a third column when True. For example: Compare column A to Column C - Rows 1-1000. If A1 appears anywhere in C1-1000 i want to return the "text" in column D. The row in D is = to the true value in C. i.e. If A1=C47 I want to return the text in D47. Then repeat this for A2-A1000. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing two combos/cells to return a value | Excel Worksheet Functions | |||
| comparing cell to row, return all matchs | Excel Worksheet Functions | |||
| Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
| sumproduct return value by comparing two criteria..... | Excel Worksheet Functions | |||
| Comparing two lists and return specified data | Excel Worksheet Functions | |||
Threaded Mode
