i.m trying to create a formula that will from a list of numbers look uo the
matching number in another list, then goto the second cell of that list and
match up the 2nd cell then return the valve in the 3rd cell

ie
list 1: c123 op.10 2.44 list 2 : c123 op.10
c123 op.20 3.56 c123 op.20
c123 op.30 5.25 c123 op.30

ie: if c123 in list 1 = c123 list 2, & op.10 in list 1 = op.10 list 2,then
return valve in cell 3 ie 2.44