Lookup based on 2 values

Originally Posted by graeme86

I have 5 columns of data

Please Login or Register  to view this content.

What i need to do is look up the Item # and location Combination from Columns A, B and match it to the item location combination in D,E and return the corresponding value from column F.

Sample attached

Thanks in advance for any help.

Graeme

You have to insert Helper Column,

See the Attach

Thanks for the help that has worked perfectly

Graeme