Hello.

What I am trying to do is return a value that is in column G *IF*
column A and column B meet my criteria. Column G is a quantity value,
and column A is a Vehicle Type and column B is Job Type.

So, if colA = Car and colB = Tires, then return the quantity of work
needed to be done.

Sounds like a simple problem. The thing is, I need to find the instance
in which the two factors are met (Car and Tires) and then return the
quantity within that row. I never know which row it may be however...
essentially, Id like to offset from the row position that the two
criteria are met.

Possible?

Sorry if this is confusing... but trust me, its more confusing here in
person.