I'm trying to create a formula that will lookup the what is in column G in
column B of another sheet. If what is in column G is in column B of the
other sheet, the word NEW is returned, otherwise the cell is left blank ("").
Any help?

Thanks!