jeetusaini85
Board Regular
- Joined
- Aug 9, 2013
- Messages
- 131
Dear All,
I have a data excel, I need a formula which will do a lookup in column A (sheet 2) to find the names which doesn’t exist in column A (sheet 1) if found it placed that name into column A (sheet 1).
For example:
Sheet 1 Sheet 2
<tbody>
</tbody>
<tbody>
</tbody>
I know lots of excel kings are here and I hope my query will resolve .
I have a data excel, I need a formula which will do a lookup in column A (sheet 2) to find the names which doesn’t exist in column A (sheet 1) if found it placed that name into column A (sheet 1).
For example:
Sheet 1 Sheet 2
Column A | Column B |
A | 1 |
Formula to place “B” automatically | |
<tbody>
</tbody>
Column A | Column B |
A | 1 |
B | 2 |
<tbody>
</tbody>
I know lots of excel kings are here and I hope my query will resolve .