I want to look in two columns. I want to look in the first column for a cell
that matches the data in another cell. And with that value, I want to find a
blank value in the second column. Once it finds the row with this value, I
want to return the value in column G of this row. Example:

Col A Col B Col G
TBD 1 20000
TBD 1 X (This is where I want to look for the
value TBD 1
in column A and blank in Col B, so
it returns
the value 20000 from column G)
TBD 2 10000
TBD 2 X

Can you help with a formula?

Thank You,

PW