I'm trying to build a sheet to help keep track of a collection of mine.

In one collection I want to list an item's condition (mint, good, fair, ect). In the next column I want to automatically pull up a value multiplier. I can wright this as a nested IF(X="Mint",2,(IF(X=...)) function, but it makes sense to reference a table on some other sheet containing the condition & values.

I know there must be a way to do this easily.

Thanks.