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
|