Hi
I have Data with column A to Column C
for Example in A column Vaules are 1,2,2,3,1,4,1,5,6,2,4......
and in B column Vaules are a,b,c,d,e,f,g,h,i,j,l,m,n,o,p.....
Now I need to Develop a formula in other sheet so that
Value of Cell A2 is as input. and result will be:
if A2=1 then
A3=1 and B3= a
a4=1 and B4= e
a5=1 and b5= g
Is it possible with formula only? I dont want to use any VBA
thanks