I wish to lookup 2 cells and if they = a certain value then set number in
another cell...
eg:

if
b2 = a4 and d2 = 1 then cell x2 = 10
b3 = a4 and d3 = 4 then cell x3 = 8
b4 = a3 and d4 = 4 then cell x4 = 8

and so on...