suppose we have

3 columns with random values

23(A1) 43(B1) 67(C1)
34(A2) 56(B2) 34(c2)
72(A3) 12(B3) 56(C3)

now if while using 56(B2) how can we extract by using formula 34(c2)

or simply...by A1...can we get B1...or by B1 can we get C1


i have tried vlookup but it doesnot work on random numbers