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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,226,730
Messages
6,192,702
Members
453,748
Latest member
akhtarf3

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
Back
Top