djcali2012
New Member
- Joined
- Feb 14, 2013
- Messages
- 1
Worksheet 1 | Posted | Worksheet 2 | Worksheet 2 |
John | ? | John | Ben |
Matt | ? | Mat | Scott |
Ben | ? | ||
James | ? |
<colgroup><col span="4"></colgroup><tbody>
</tbody>
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...