Please help

[gysgt_88]

Here is what I am trying to do:
I have different names in a cell. If the name matches another cell on the same worksheet, the data I enter to the right in the next two cells transfers that data to the right two cells of the matched name. Currently I am entering it twice because the names are in different rows and columns but if a name matches, I would like to only enter the data once in the next to cells to the right and have it transfer the exact data.

Thanks in advance!

 

[hiker95]

gysgt_88,

Welcome to the MrExcel forum.

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?


I would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


If you are not able to provide screenshots, then:

You can post your workbook/worksheets to the following free site (sensitive data changed), and provide us with a link to your workbook:

https://dropbox.com

 

[gysgt_88]

I am using Windows 7. I am using Excel 2013

BOWLER LANE	BOWLER ID	NAME	5TH FRAM SCORE	FINAL SCORE		POSITION IN 5TH FRAME	NAME	5TH FRAM SCORE	FINAL SCORE		FINAL SCORE	NAME	PARTNER	NAME	FINAL SCORE	TOTAL SCORE
	1	CED	90	155	1	TI	150	211	155	CED	<tbody> </tbody>	CH	99	254
	2	PA	85	145	2	ED	120	135	145	PA	<tbody> </tbody>	AN	145	290
	3	ED	120	135	3	VA	116	208	135	ED	<tbody> </tbody>	BO	123	258
	4	EA	48	185	4	DO	115	187	185	EA	<tbody> </tbody>	JA	175	360
	5	PAU	69	143	5	BR	114	175	143	PAU	<tbody> </tbody>	WA	254	397
	6	EAB	58	158	6	CED	90	155	158	EAB	<tbody> </tbody>	BRB	210	368
	7	ST	76	255	7	PA	85	145	255	ST	<tbody> </tbody>	CY	245	500
	8	BR	114	175	8	AN	85	145	175	BR	<tbody> </tbody>	TI	211	386
	9	DO	115	187	9	CH	82	99	187	DO	<tbody> </tbody>	VA	208	395
	10	VA	116	208	10	ST	76	255
	11	TI	150	211	11	PAU	69	143
	12	CY	26	245	12	EAB	58	158
	13	BRB	29	210	13	BO	49	123
	14	WA	22	254	14	EA	48	185
	15	JA	45	175	15	JA	45	175
	16	BO	49	123	16	BRB	29	210
	17	AN	85	145	17	CY	26	245
	18	CH	82	99	18	WA	22	254

<colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[gysgt_88]

See tab 18

https://www.dropbox.com/s/fayf97sfuyvwxev/HI-LOW.....xlsx?dl=0

 

[hiker95]

gysgt_88,

I do not understand what you are trying to do.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[gysgt_88]

Basically the names in column C will never change. Those same names are in column H but in a different order. When I type into column D and E beside the name, I would like the data transferred over to column I and J beside the same name.

https://www.dropbox.com/s/fayf97sfuyvwxev/HI-LOW.....xlsx?dl=0

see tab 18

 

[gysgt_88]

bump