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
[TABLE="align: left"]
<tbody>[TR]
[TD]Column A
[/TD]
[TD]Column B
[/TD]
[/TR]
[TR]
[TD] A
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Formula to place “B” automatically
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

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 .

 

[jeetusaini85]

Sorry,,,,, i think i am bothering you ............

Ok, now i will explain what i want .............

Sheet 2 Sheet 1
Column A Column A
A A
B B
C A
C
B

Now when i write "D" in column A into sheet 2, Column A sheet 1 formula calculate that Is "D" already in the Column A sheet 1if yes do nothing if not "D" should be add in the Column A sheet 1list.

Thanks

 

[Andrew Poulsom]

You're not bothering me.

As I said before why do you need to duplicate your data? Why can't you just use what's on Sheet2? Remember that you can see your workbook but I can't.

 

[jeetusaini85]

Yaa i know you can't see my workbook, i just want a formula which can prepare a list from a column data of unique entries.

May be you can understand what i want as a formula to look this...

Excel - Unique and duplicate values | Get Digital Help

Many thanks and appreciated.....

 

[Andrew Poulsom]

So why don't you use the formula here:

How to extract a unique distinct list from a column in excel | Get Digital Help - Microsoft Excel resource

Just adjust the reference to suit.

 

[jeetusaini85]

i found it Anderw, i m sure you can guide me through....

http://cdn.get-digital-help.com/wp-...-distinct-sorted-values-from-a-cell-range.xls

 

[Andrew Poulsom]

Guide you through what?

 

[jeetusaini85]

Let me try this and many thanks to you to assist me. Thanks a lot

 

[jeetusaini85]

Hey Andrew,. again stuck... copy and past the VB code into my excel and try but did not work. I m tired now....

 

[Andrew Poulsom]

See if you can adapt this example (formula in B2 copied down):

Excel 2010
	A	B
1	Names	Unique
2	Bill	Andrew
3	Edward	Bill
4	John	Charles
5	Andrew	David
6	Ian	Edward
7	Charles	Fred
8	Harry	George
9	George	Harry
10	David	Ian
11	Fred	John
12	Andrew
13	Charles
14	Edward
15	Bill
Sheet1

Cell Formulas
Range	Formula
B2	{=IFERROR(INDEX($A$2:$A$15,MATCH(0,COUNTIF($A$2:$A$15,"<"&$A$2:$A$15)-SUM(COUNTIF($A$2:$A$15,"="&B$1:B1)),0)),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[jeetusaini85]

Thanks Dear,

VB working fine and query resolve.... many thanks to you for you assistance and guidance...

Thanks