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

=IF(LEFT(A1,10)=B1,RIGHT(A1,4),"")

You could put the above formula in column C. This will only work
consitently if the the length of the data in column a and b is conistent.

"NED" wrote:

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