Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two combos/cells to return a value
Hello,
Having trouble comparing two different files. In one file i have to compare a combination of numbers (ex: 2030 - 1020 would be 1 combo, 2030 - 1302 is another combo). These combos are also located in a second file (two diff columns). Is there a function that exists that will let me compare these two files to return a another cell in the second file? example: file 1: 3040 2030 file 2 3040 2030 Value3 Value4 need to be able to get the comparison to reutrn value3 and value4 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing cell to row, return all matchs | Excel Worksheet Functions | |||
sumproduct return value by comparing two criteria..... | Excel Worksheet Functions | |||
Entering combos without converting it to dates? | Excel Discussion (Misc queries) | |||
Comparing two lists and return specified data | Excel Worksheet Functions | |||
return array result in cell based on comparing dates | Excel Worksheet Functions |