Multiple Column Comparison and Value

[darklogix]

Hello all,

Wasnt sure the best title for the post, I'll do my best to explain my situation

I have 2 sets of data that would look something like this:

A B C and then F G H
Value Value Value empty Value Value
Value Value Value empty Value Value
Value Value Value empty Value Value
Value Value Value empty Value Value
...

Essentially I need the following to happen
If the combination of G2 Matches any value in Column B AND H2 matches any value in column C on the same row (as G2 matching a B column value) then I need F2 = A(Whatever row the double match exists).

Please tell me there is a way to do this Any help would be greatly appreciated.

[MarvinP]

Hi darklogix and welcome to the forum,

A short example is needed. Click on the "Go Advanced" under the message area and then on the Paper Clip above the message to attach a sample file. Give us about 6 rows of data with some that give results and some that don't and explain why.

This will give us a better understanding of the problem.