# excel & lookup

1. ### Vlookup Help

Sheet 1 - This has a code column Sheet 2 - this also has a code column Expected result Sheet2 also has a column where in Codes Values are Yes and No values are mentioned So when I do Vlookup based on Matching Code Names I want to match it with the Code Values and return the results as Yes...
2. ### Vlookup Help - Yes and No

I have created a Vlookup formula on one of the columns on a workbook. This Vlookup will look for part numbers on the other Workbook and paste the ones that are matching and others that are not matching will showup as NA I want to change this formula in a way that. Anything that Matches should...
3. ### Macro to Find a match and update corresponding value

Hello All, I have something similar situation on my workbook. Sheet1 has large amount of data with Product name (column A) and current value (column D). There are some blank records in between too. Sheet2 has Product name (column A) and sold amount (column B). There are no blank records in...
4. ### Loop through Pivot table to copy cell values to another sheet

I am trying to loop through my pivot table to copy the sum values to another sheet. The issue I am facing is, the row variables are dynamic and change when there is a data change, so when there is no variable D or S my loop does not run. Can anyone help me with how to make this work? The...
5. ### Cumulative data based on expiration date fill cell

I have a spreadsheet that need to track the total sq ft active for each month/year until expiration based, when the contract expires I need it to fall off in the cell Property Sqft Expiration Date A 21,000 12/31/2021 B 522 1/15/2023...
6. ### Count if based on sets of data

Hi I am trying to get a total in column B. The total computation is as follows: 1. Row 1 has the 4 same dates with Set 1 to 4 in row 2. 2. The total is computed if there is at least 3 "Y" for a date. For the first guy, he has 4 Y in first day and 3 Y in 3rd day so it is 2 for the second guy, he...
7. ### Match rows for value in specific columns and paste matched/unmatched rows in new sheet

I got data in sheet1 and sheet2, which i want to copy and paste in sheet3. That is already done. So next i want to match rows, by checking column C, D, E, H and I. The C and H column value is integer and the rest is text/strings. If two rows match, then i want to copy and paste one of the lines...
8. ### Make data input from multiple workbooks in one master workbook

Hello, i would like to make a data input from two workbooks that is in the same path. The data input should be in the master workbook from those two files. The first sheet in the master workbook should just be empty as im going to make macro run buttons for later purpose. The data from the first...
9. ### Insert data from two worksheets into master workbook and match values

Hello everyone I would love some help to develop some VBA code. But im very new to VBA. Hope someone can help me with it, and i know its a lot to implement. So its for private purpose and a "just for fun project". The project is that i want to two files in a path that i want to match with...
10. ### #Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Follow Condition )

#Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Sheet 1 many Spaces in there , So i Need "invoice Number list" on Sheet 2 (Auto Generated) how to possible get data as a list format, NOTE: SHEET 1 : *** So many Space in there*** SHEET 2...
11. ### Cost Calculation Based on Dropdown List

I have an excel file that has 2 sheets. 1 for tracking services rendered and another with a list of customers and their fees per service. Tracking Sheet For each service, we manually enter a number for how many times the service was rendered. We then select the client from a drop-down list...
12. ### Autogenerate serial number according cell reference Number ????

Autogenerate serial number according cell reference Number ???? I have try cell Reference : A2 =11 i try cell reference A2 to B3 , problem is B3 Cell value According Auto generate serial Number.
13. ### How to remove unuse area in classics pivot table ?????

i need only one Column , how to remove unuse area in classics pivot table ????? Show me how to delete empty column formatting
14. ### How to show selected menu in slicer to other cell ??? (Like a Refrence Indication)

@ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference

16. ### Make One Dropdownlist , Including all table Column Cell Details Show without Dependent Dropdownlist ?

@ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...
17. ### Excel Formula - Count duplicates in Column B per Name (Column A)?

Hi All, Sorry not good with excel formula, can you help me construct formula how can I count how many duplicates we have in Column B per Name (Column A)? Sample result should be: Rose - 1 (2 Red) Joy - 1 (2 Purple) Angel - 2 (2 Blue & 2 Red)l
18. ### Automatic value insertion to table based on date

Hi, I'm trying to figure out a way to make daily performance tracking easier. I have a table X with dates, performance (ie. sales) and seller. Example below: Date Person A Person B 14.4.2021 100 200 15.4.2021 150 50 16.4.2021 250 100 Currently each person has to go and manually...
19. ### HELP!! cant figure this out (6 hours still going)

ok to start off with ,, thank for taking the time here to read this ive litterally been learning vla for 24-48 hours and im stuck with a few things i wondering if i could pick your brains to help soo.. ive attached a spreadsheet where im wanting to add a new line after pasting to my database...
20. ### Finding unique Value of corresponding duplicate value (Brain Teaser)

In one sheet I have data in one row (Style Number, Column A) which has many duplicates, but every corresponding value of that (each) duplicate value has a unique value (Item Code, Column B). In sheet 2, I have got just Style Number (Column A). How can I match the Column A in both the sheets...

### 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?

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