I want to take a value from one worksheet(W1) and place it in another(W2) based on a conditional. In order to do that I need to reference the if from a different cell and return value to still another cell?? 3 cells at least??
if W2(a1)=1,W2(a2)=W1(b1), W2(a2)=0 Does that work??
Thanks for the reply. I suspected as much. I think I will try brute force and a couple other cells.
I would like to be able to test a cell with- if -and return a value from another cell(sheet). Is there a way around circularity here? I am not VBA literate. Barely excel literate. if A1=1,A1= sheet2(B1), A1=0