Enter Value next to Lookup value using command button

syedhani

New Member
Joined
Mar 15, 2021
Messages
1
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
  5. 2011
  6. 2010
  7. 2007
Platform
  1. Windows
  2. Mobile
  3. Web
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".
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Forum statistics

Threads
1,148,189
Messages
5,745,238
Members
423,936
Latest member
Conservatopia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top