Need a lookup to find a name - Urgent

[jeetusaini85]

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

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 .

 

[Andrew Poulsom]

Like this?

=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

 

[jeetusaini85]

Once again thank to help me Andrew....

What i want is==>

1. Formula should check first the names into sheet 2 column A (Which enter by manually)
2. After checking it should check same thing into Sheet 1 column A
3. If a name which does not exist into Sheet 1 column A
4. Copy that name into sheet 1 column A cell automatically
5. Formula address is = Sheet 1 column A2 and continue A3, A4 etc...

Note : name in the sheet 2 column A can be duplicate so formula should capture the name only 1 time into sheet 1 column A.

Hope it make sense, i got headache to find and try this type of formula.

Thanks

 

[jeetusaini85]

In short - i want those name (Uniquely) which are placed into Sheet 2 column A automatically into Sheet 1 column A so that i can count other things against them. I can use pivot table but when a new name enter into Sheet 2 column A and after refresh pivot table new name can show into list but other formulas are not automatically add to the new name row wise. I think you can make a macro regarding this query for me .

Thanks Andrew

 

[Andrew Poulsom]

Why do you need to duplicate your data?

 

[jeetusaini85]

Actually, the entries will enter by person who will sold goods and a single person can sold multiple items,so person name can be multiple but in the Sheet 1 column A will only show single name.

 

[Andrew Poulsom]

Why can't you use a pivot table with a dynamic source?

http://www.contextures.com/xlPivot01.html

 

[jeetusaini85]

Ok, i think an array formula can work for this.

 

[jeetusaini85]

In dynamic source pivot table, how row formula can automatically add when a new name enter and refresh?

 

[Andrew Poulsom]

What do you mean by 'row formula'? Please try to be more specific about how your data is laid out and what results you want from it.