Enter Value next to Lookup value using command button

[syedhani]

i have an excel data of over 10,000 rows. i need to create a drop down on top of the sheet that will display the values of a particular column on that sheet.
I need a command button that will search for the value selected from the drop down on the sheet and enter "checked" on the same row next to the looked up value on column "z". looked up column will be "B"

Drop down list will be cell "b2"
data starts from row a5 and keeps increasing as data is entered onto the sheet
Data is entered all the way from Column A till Column Y

So if you click the command button, it will search for the value selected on cell B2 and identify the value appearing in the data below (example the data is found on cell A2800 and then paste "checked" on the same row on column Z2800.

If record found on cell A1200, then data to be pasted on cell Z1200 and so on and so forth


In case data not found, a msg box to appear saying "Match Not Found".