Match for a single Column using the same Column header in 2 different worksheets

[djcali2012]

[TABLE="width: 340"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD]Worksheet 1[/TD]
[TD]Posted[/TD]
[TD]Worksheet 2[/TD]
[TD]Worksheet 2[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]?[/TD]
[TD]John[/TD]
[TD]Ben [/TD]
[/TR]
[TR]
[TD]Matt [/TD]
[TD]?[/TD]
[TD]Mat[/TD]
[TD]Scott[/TD]
[/TR]
[TR]
[TD]Ben [/TD]
[TD]?[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]?[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I need to return a match to worksheet1 if the names exist in either worksheet 2 or worksheet 3. The formula I normally use is =IF(ISERROR(MATCH(D1,$A$1:$A$300,0)),"",B1) but wrather than searching 1 column ; I'm need to search 2...

 

[raj2206]

Hi, Could u please explain the problem a little more,

Thanks/Raj