Thanks! Sorry, I wasn't very clear...By the formula I meant what gets each item on the drop down list to have a separate "google sheets formula or number" so that each item is different, not just the cell itself. From most of the posts, it seems that VLOOKUP is what I need to research. Thanks again!