Transfer values for matched columns

[nooredein]

Hey everybody;

Please let me find formula for this:
I need to transfer the values of matched names in one column to appear in front of its matched names in another column.
In my example I want values of matched names form column "D" to
appear in column "H" in front of those matched names.


thank you

[FDibbins]

Try this, copied down...
=IFERROR(VLOOKUP(G4,$C$4:$D$8,2,0),"")

[nooredein]

Try this, copied down...
=IFERROR(VLOOKUP(G4,$C$4:$D$8,2,0),"")

I afraid it is not working with me,
Please show me how it does...
thank you...

[FDibbins]

	C	D	E	F	G	H
3	Name	HBA1c			Name	HbA1c
4	John smith	7.2			Fred Suliman
5	Leonard David	5.5			Sarah longman
6	Sandra Golden	6.7			Sonia Julian
7	Dalia fredman	9.1			Leonard David	5.5
8	Sylvia Donald	5.4			Sylvia Donald	5.4
9					Farah Abbas
10					Lilian Jonthan

H4=IFERROR(VLOOKUP(G4,$C$4:$D$8,2,0),"")
copied down

[nooredein]

You are Great!!

thank you

[FDibbins]

Happy to help and thanks for the feedback

[nooredein]

Happy to help and thanks for the feedback

Just one more query,

what would be the formula if the HBA1c column is "F", ie, it lies 2 column or more away from column "C"

[FDibbins]

In my formula...
H4=IFERROR(VLOOKUP(G4,$C$4:$D$8,2,0),"")
the lookup range is $C$4:$D$8, if you range is wider/greater than that, you just need to adjust to suite

Then, the bolded 2 is the number of columns across to go, to get the answer...in your sample, it was 2, but if you need to go across 2 more, then that would be 4