This may better explain my data. The numbers on the right are the soil types.
They are mostly numbers but some are numbers and letters.
I have a worksheet where you can enter the soil type (numbers and letters)
and then in a column next to that it will automatically bring in
the dollar amount.

Does that help explain it better?

SRR Soil Map Unit Symbols
$119 35 247 362 525 1016 1030 1075 1080 1084 1091 1095 1834
27B 327B 39A 39B 41A 41B 611C 920C2 920D2 960F L205A

$129 255 269 392 517 539 1228 1213C 920B 921C2 960D2 L13A L200A

$141 112 114 386 1092 1833 1229B 944B 945C2 L163A L84A

$154 86 313 956 978 1213B L107A L184A L185B L34A

$168 109 113 336 414 887B 945B L83A

$181 118 239 102B 106B 1204B 1207B 1901B 238B 94B L85A


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.