i have column A1 to A10 and another column B1 to B10
In my Column C1 to C10 is the value entered by customers ( from any One of A1-A10)
If C1 = Any of A1-A10 ;(which match any A1-A10 numbers) Then D1 should pop up the Value from B1-B10 corrosponding to A1-A10
for example C1= A5 ; then D1= B5
for example C2= A2 ; then D2= B2
for example C3= A10 ; then D3= B10
.....
this is done in excel
please help thanks
Bookmarks