Formula Advice Needed
 

I am trying to do the following:
Look up a numerical value in column G from another sheet and find the match
G in current sheet... if that is true then Look up a numerical value in
column F and find a match in current sheet... if that is true than check to
see if column C on current sheet is between the numbers in columns B and C on
the other sheet...

If all are true, put what is in column H on the other sheet into the current
cell. Column H is text.

I tried a Sum Product, but it giives me 0 since column H is text. Is there
any other ideas?

bump

"Brad_A" wrote:

I am trying to do the following:
Look up a numerical value in column G from another sheet and find the match
G in current sheet... if that is true then Look up a numerical value in
column F and find a match in current sheet... if that is true than check to
see if column C on current sheet is between the numbers in columns B and C on
the other sheet...

If all are true, put what is in column H on the other sheet into the current
cell. Column H is text.

I tried a Sum Product, but it giives me 0 since column H is text. Is there
any other ideas?