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