Hi All,

I've got 3 columns, all of which are text fields, I'm trying to return the text field in column 3 based on matching the fields in the 1st 2 columns,

i.e. Col 1 Col 2 Col 3
11101-3000 11101-4000 abcd
11101-4000 12014-1500 xyza
11102-4000 12536-5000 azyb

So if I tried to find 11101-4000 in Column 2 & return the result of abcd what do I need to do. I want to apply this argument to the entire column.

I've tried sumif & vlookup fuctions but I can't get the result I need.

Thanksin advance
tt