Posts by rsrlh2

    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??

    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