Lookup Func : find w/ argument

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.

Hi

Have a look at the VLOOKUP function. You can build a list of the conditions and the multipliers, then get the relevant multiplier for the condition.

rylo