if one cell has 6 digit number that matches 6 digit number in another row /another sheet then return contents of another rown

[IsabellaLearning]

Its late,
Ive tried so hard by myself to make it work
I hope this makes sence to someone...

One workbook, 2 sheets "Master and "Voucher"

if column/ROW "U2" in the sheet called "voucher" matches
any cell in column A in 2nd sheet called "Master"
then add the contents of the same row from "voucher" sheet to
column AN "Master sheet row H - (MATCHING line)

any ideas if this is possible?
Isabella

 

[LloydFinancials]

So I am trying to understand what you are saying. You are going to lookup the value in U2 on the Sheet Voucher in column A of Master, and if found, copy Columns V to AN and paste into column H of Master like the following?

Excel 2010
	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN
1
2	2	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a
3	3	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a
4	4	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a
5
Voucher

Results

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	1
2	2							a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a
3	3							a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a
4	10
Master

Luke

 

[IsabellaLearning]

thanks luke there are 2 sheets
master and voucher

in "master" sheet column A
in "voucher" sheet column u
both contain matching data.

What I want to do is put a formula in "master" sheet column F that puts the contents of column AN "voucher" sheet when it finds a match in the rows of "master" sheet column A with in "voucher" sheet column u

Does that make more sense?

Isabella

So I am trying to understand what you are saying. You are going to lookup the value in U2 on the Sheet Voucher in column A of Master, and if found, copy Columns V to AN and paste into column H of Master like the following?

Excel 2010

	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN
1
2	2	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a
3	3	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a
4	4	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a
5

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Voucher​

Results

Excel 2010

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	1
2	2							a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a
3	3							a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a	b	c	a
4	10

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Master​

Luke

 

[LloydFinancials]

Ok I see, I think.

Here is an example of what I think you are doing. You will have to modify the cell references to your sheet, ie last row of tables.

Here is what I have on the voucher sheet column U and column AN:

Excel 2010
	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN
1	x																			a
2	y																			b
3	z																			c
4	x																			d
5	y																			2
6	z																			e
7	x																			f
8	y																			g
Voucher

And this is what I have on the Master sheet columns A and F. Column F returns a value from Voucher column U if Column A matches Voucher coulumn AN.

Excel 2010
	A	B	C	D	E	F
1	1
2	2					y
3	3
4	4
5	5
6	6
7	7
8	8
Master

Cell Formulas
Range	Formula
F1	=IFERROR(INDEX(Voucher!$U$1:$U$8,MATCH($A1,Voucher!$AN$1:$AN$8,0)),"")

 

[IsabellaLearning]

THANKYOU, THANKYOU, THANKYOU - YOU MADE MY DAY!!!




jUAN

Ok I see, I think.

Here is an example of what I think you are doing. You will have to modify the cell references to your sheet, ie last row of tables.

Here is what I have on the voucher sheet column U and column AN:
Excel 2010

	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN
1	x																			a
2	y																			b
3	z																			c
4	x																			d
5	y																			2
6	z																			e
7	x																			f
8	y																			g

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Voucher​

And this is what I have on the Master sheet columns A and F. Column F returns a value from Voucher column U if Column A matches Voucher coulumn AN.

Excel 2010

	A	B	C	D	E	F
1	1
2	2					y
3	3
4	4
5	5
6	6
7	7
8	8

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Master​

Worksheet Formulas Cell Formula F1 =IFERROR(INDEX(Voucher!$U$1:$U$8,MATCH($A1,Voucher!$AN$1:$AN$8,0)),"") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[LloydFinancials]

Thank you!