If you have soil type in Q34:Q56 and corresponding dollar in R34:R56 try the
below formula which will return the formula

=IF(ISNA(MATCH(C11,Q34:Q56,0)),0,INDEX(R34:R56,MAT CH(C11,Q34:Q56,0)))

If this post helps click Yes
---------------
Jacob Skaria


"Keith - NRCS" wrote:

I hope there is an easy answer to my formula problem so I will try to explain
the best that I can. I am trying to relate ranges of soil types to their
corresponding dollar amounts.

Here is the formula I have working so far:
=IF(OR(C11=Q34,C11=Q35,C11=Q36,C11=Q37,C11=Q38,C11 =Q39,C11=Q40,C11=Q41,C11=Q42,C11=Q43,C11=Q44,C11=Q 45,C11=Q46,C11=Q47,C11=Q48,C11=Q49,C11=Q50,C11=Q51 ,C11=Q52,C11=Q53,C11=Q54,C11=Q55,C11=Q56),R5,0)

Basically this formula takes into account what is entered into cell C11
(soil type) and it relates a corresponding dollar amount to it. The problem I
am having is that I have 4 more ranges of cells and each range of those cells
has a different corresponding dollar amount.

I am on the right track because the formula above works as long as I enter a
soil type from the first range of soil types. Basically I need to add on to
the formula above.

Also if there is a way to shorten the formula and have it recognize a range
of cells...I know you can do that but I was getting an error when I tried to
highlight the entire range so I had to click each cell individually to get it
to work. Any tips or help would be greatly appreciated.