Data Validation, Hlookup saving data issues

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)&"","")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top