Copy from sheet to sheet Vlookup???

[ukmxer]

I want to transfer a cell contents from one sheet to another but I need to locate the cell number on sheet 1 so I can copy from sheet 2.

Sht 1 (master)

A B F
Race no. Name Race 1 points
101 fred
102 John
103 larry
104 sid
105 Mark
106 steve

Sht2(race results)

A B C D
Position Race no. Name Points
1 103 larry 15
2 106 steve 10
3 101 fred 5

I want to transfer the points back to sht1 and put a zero in the points of everyone who finished outside the top3.



It was all spaced out in columns when I submitted it but it has compressed it all on the forum screen , sorry but i do not know how to correct it.

[JustinBram]

create a spreadsheet with what you want to do and upload it (you must zipped the spreadsheet before uploading). It will make it easier to view and actually see what you want to accomplish, also add some comments at the side of the cells you are working on.

[antoka05]

Have a look to attached file... I hope it's what you need.
Macro put '0' in column 'f' of 'sheet1', then for each row in sheet2 look for 'Race no.' string in sheet2 and if found the element move point to sheet1.

Regards,
Antonio

[ukmxer]

Antoka05 , thank you. Yes that is what I wanted to do.

I will have a closer look and if I have any problems or queries I will get back to you.