Comparing two combos/cells to return a value

R

ravity

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OR Exact statement not working to compare values in two columns 4
Compare 1 cell to column of cells returning adjacent cells info? 1
Comparing two columns and return a third 3
Return a value if item does not appear on list 1
Conditional Formatting to Compare Two Sheets of Data 1
Help with Function: Compare text and and edit in cells 2
Compare two cells in two different files and return answer 6
Can I compare more than two merge field values using =AND or =OR? 3

Top