Brian,

Yes, your formula will work, but this is the programming group. So,
perhaps, post code to put that formula into cell H4 and to copy it down to
match column G. The OP may also not want formulas, so also include code to
convert those formulas to values.

Bernie
MS Excel MVP

"BrianB " wrote in message
...
A simple VLOOKUP should do the job. In cell H4 put formula :-
=IF(ISERROR(VLOOKUP(G4,Sheet1!G:G,1,FALSE)),"","X" )

and copy down.


---
Message posted from http://www.ExcelForum.com/