Vlookup

[WomenPC]

podate dorep dofed shippingdate
7/6/11 254545553 254545553 7/11/2011
7/7/11 365636546 425435455 7/11/2011
7/8/11 367756546 485457485 7/12/2011
7/9/11 425435455 574957435 7/12/2011
7/6/11 635636636 619755435 7/12/2011
7/6/11 636363663 696879779 7/11/2011
7/9/11 708005858 708005858 7/11/2011
7/8/11 780457584 786908457 7/12/2011
7/9/11 854058697 798045584 7/11/2011
7/10/11 867675676 867675676 7/11/2011
7/10/11 868676546 911979797 7/12/2011

Hello, There two tables. both have two columns.
well, I need the podate next to the column [dorep] which the number match with the column [dofed]. Im using a VLOOKUP but show #NA...PLEASE HELP!

 

[cgcamal]

HI WomenPC,

I´m not sure which result do you need:

Try with (copy down the formula):

Excel Workbook
	A	B	C	D	E
1	podate	dorep	dofed	shippingdate
2	07/06/2011	254545553	254545553	07/11/2011	07/11/2011
3	07/07/2011	365636546	425435455	07/11/2011
4	07/08/2011	367756546	485457485	07/12/2011
5	07/09/2011	425435455	574957435	07/12/2011
6	07/06/2011	635636636	619755435	07/12/2011
7	07/06/2011	636363663	696879779	07/11/2011
8	07/09/2011	708005858	708005858	07/11/2011
9	07/08/2011	780457584	786908457	07/12/2011
10	07/09/2011	854058697	798045584	07/11/2011
11	07/10/2011	867675676	867675676	07/11/2011
12	07/10/2011	868676546	911979797	07/12/2011
...

Cell Formulas
Range	Formula
E2	=LOOKUP(B2,$C$2:$C$12,$D$2:$D$12)

Regards.

 

[WomenPC]

Hi Cesar,

You should speak spanish like me
Well, I would like get the podate which belongs to separate report to the [column e]. So, the result should be 7/6/11.

Please help me!

 

[cgcamal]

Yes, I speak Spanish .

Maybe like this:

Excel Workbook
	A	B	C	D	E
1	podate	dorep	dofed	shippingdate
2	07/06/2011	254545553	254545553	07/11/2011	07/06/2011
3	07/07/2011	365636546	425435455	07/11/2011	07/09/2011
4	07/08/2011	367756546	485457485	07/12/2011	07/09/2011
5	07/09/2011	425435455	574957435	07/12/2011	07/09/2011
6	07/06/2011	635636636	619755435	07/12/2011	07/09/2011
7	07/06/2011	636363663	696879779	07/11/2011	07/06/2011
8	07/09/2011	708005858	708005858	07/11/2011	07/09/2011
9	07/08/2011	780457584	786908457	07/12/2011	07/08/2011
10	07/09/2011	854058697	798045584	07/11/2011	07/08/2011
11	07/10/2011	867675676	867675676	07/11/2011	07/10/2011
12	07/10/2011	868676546	911979797	07/12/2011	07/10/2011
...

Cell Formulas
Range	Formula
E2	=LOOKUP(C2,$B$2:$B$12,$A$2:$A$12)
E3	=LOOKUP(C3,$B$2:$B$12,$A$2:$A$12)
E4	=LOOKUP(C4,$B$2:$B$12,$A$2:$A$12)
E5	=LOOKUP(C5,$B$2:$B$12,$A$2:$A$12)
E6	=LOOKUP(C6,$B$2:$B$12,$A$2:$A$12)
E7	=LOOKUP(C7,$B$2:$B$12,$A$2:$A$12)
E8	=LOOKUP(C8,$B$2:$B$12,$A$2:$A$12)
E9	=LOOKUP(C9,$B$2:$B$12,$A$2:$A$12)
E10	=LOOKUP(C10,$B$2:$B$12,$A$2:$A$12)
E11	=LOOKUP(C11,$B$2:$B$12,$A$2:$A$12)
E12	=LOOKUP(C12,$B$2:$B$12,$A$2:$A$12)

Hope this is what you're looking for, if not and if you feel better to explain it in Spanish
you can open a new question in "Other languages" side directly in Spanish

Best regards.

 

[WomenPC]

I'm ok in English.

but it not is which im looking.

The table B [column C] has just 4 records that match with the table A [column B] I want look into the table A the records in the table B for get the podate.

I receive two different reports, so I need a formula to get this data (podate) to a new report.

I hope that you can help me

 

[WomenPC]

Hey, i resolved it! thanks anyway

 

[cgcamal]

Is this close to what you need?

Excel Workbook
	A	B	C	D	E
1	podate	dorep	dofed	shippingdate
2	07/06/2011	254545553	254545553	07/11/2011	07/06/2011
3	07/07/2011	365636546	425435455	07/11/2011	07/09/2011
4	07/08/2011	367756546	485457485	07/12/2011
5	07/09/2011	425435455	574957435	07/12/2011
6	07/06/2011	635636636	619755435	07/12/2011
7	07/06/2011	636363663	696879779	07/11/2011
8	07/09/2011	708005858	708005858	07/11/2011	07/09/2011
9	07/08/2011	780457584	786908457	07/12/2011
10	07/09/2011	854058697	798045584	07/11/2011
11	07/10/2011	867675676	867675676	07/11/2011	07/10/2011
12	07/10/2011	868676546	911979797	07/12/2011
...

Cell Formulas
Range	Formula
E2	=IFERROR(INDEX($A$2:$A$12,MATCH(C2,$B$2:$B$12,0),1),"")
E3	=IFERROR(INDEX($A$2:$A$12,MATCH(C3,$B$2:$B$12,0),1),"")
E4	=IFERROR(INDEX($A$2:$A$12,MATCH(C4,$B$2:$B$12,0),1),"")
E5	=IFERROR(INDEX($A$2:$A$12,MATCH(C5,$B$2:$B$12,0),1),"")
E6	=IFERROR(INDEX($A$2:$A$12,MATCH(C6,$B$2:$B$12,0),1),"")
E7	=IFERROR(INDEX($A$2:$A$12,MATCH(C7,$B$2:$B$12,0),1),"")
E8	=IFERROR(INDEX($A$2:$A$12,MATCH(C8,$B$2:$B$12,0),1),"")
E9	=IFERROR(INDEX($A$2:$A$12,MATCH(C9,$B$2:$B$12,0),1),"")
E10	=IFERROR(INDEX($A$2:$A$12,MATCH(C10,$B$2:$B$12,0),1),"")
E11	=IFERROR(INDEX($A$2:$A$12,MATCH(C11,$B$2:$B$12,0),1),"")
E12	=IFERROR(INDEX($A$2:$A$12,MATCH(C12,$B$2:$B$12,0),1),"")

Regards