I have 2 input cells, eg: A1 and b1 where I can input 2 neumeraicls.

I also have a table in the same sheet with different numbers on 2 coloms and part numbers on the third colom. eg:c1 to c10 and d1 to d10 and part numbers on e1 to e 10.

If 1 put sizes in a1 and b1, i need to look up c1 to c1 and d1 to d10 and when a match is found use the part number from e1 to e10. eg: i type in 800 in A1 and 600 in B1, I need to match A1 (800) with c1 to C10 and match B1 (600) with d1 to d10. the match will be on a single row and colom e will have the corresponding part number which as to be the ourput.

I have been struggling with this. Any help is greatly appreciated.