P
pastrypat
C column has a person's name on top(Chosen by a dropdown), and each row below has values
G-Z Columns are a table for each person to retain information entered in column C
Essentially, you choose your person with dropdown C9, and C10-C20 you enter values for items; then the table auto populates based on your values..
However, once I change the person, the values I choose disappear... how can I get my table to retain the chosen values?
=IFERROR(HLOOKUP(H$9,$C$9:$C$29,5,FALSE)&"","")
G-Z Columns are a table for each person to retain information entered in column C
Essentially, you choose your person with dropdown C9, and C10-C20 you enter values for items; then the table auto populates based on your values..
However, once I change the person, the values I choose disappear... how can I get my table to retain the chosen values?
=IFERROR(HLOOKUP(H$9,$C$9:$C$29,5,FALSE)&"","")