Excel Lookup Formula

[kumar lama]

Hello,

I have one master sheet called List like below

Paul Victorio	5300_FC	5000_RO	3500_RO	2600_RW
Ryan Lamban	5300_FC	5000_RO	3500_RO	2600_RW
Sam Kim	5300_FC	5000_RO	3500_RO	3200_RO	3000_RO	2900_RO	2600_RW
Suhail Nhenol	5300_FC	5000_RO	3500_RO	2600_RW
Mamerto Benedicto	5300_FC	5000_RO	3500_RO	3200_RO	3000_RO	2900_RO	2600_RW
Jim Duffy	1700_RO	5300_FC	5200_RW	5100_RO	5000_RO	3500_RW	3300_RO
Aphan Badidil	5300_FC	5000_RO	3500_RO	2600_RW
Rashid Ali Khan	5300_FC	5000_RO	3500_RO	2600_RW
Jun Oyales	5300_FC	5000_RO	3500_RO	2600_RW
Katerina Evangelatou	5300_FC	5000_RO	3500_RO	3200_RO	3000_RO	2900_RO	2600_RW
George Dalton	5300_FC	5100_RO	5000_RO	3500_RW	3200_RO	3000_RO	2900_RO

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

And i have another Sheet Called Sheet1

Name 1000 1100 1200 1300 1400 1500 Paul Victorio <tbody> </tbody><colgroup><col><col span="6"></colgroup>
And i want update sheet 1 from List sheet. if list sheet match with sheet 1 column number, but here i am facing problem is my master list number is like 1000_wd or 1000_RO or 1000_FC, but number is appear once only. and my

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