Hi Everyone,

I am new to this post and was hoping you guys could help me out.

Suppose that I have ROWS 123 and COLUMNS "XX" "A" "B" "C"

XX A B C
1
2
3
say I have a separate title for A B C
A = X, B=Y, C=Z
and I wanted to create a table so that if CELL A1 = "yes" then insert "X" in CELL "XX1"
but I want to have it so that if CELL B1 is = "yes" then insert "Y" in column "XX1" and so on....
I can put in the formula =if(A1,"yes",X,"") which gives me what I want
for the first CELL but i dunno how to apply this formula across the
entire row which has like 30 over columns.

If you guys could help that would be much appreciated!

Thanks,
AL