vloockup

Hello everyone, I need a bit of help. I need some formula that will make me the following… if the text in the A column of "sheet1" is the same as the text anywhere in the A column of "sheet2", and also if the text in the B column of "sheet1" is the same as the text anywhere in the B column of...

i have a table of 6 column first 3 tables already have data in it in a certain sort i would like to keep second 3 table which i will put data in i want if any data i put in column let say 6 matches with any data with column 3 it will put what i wrote in same row number as its in column 1 let...

Hi there, I have a sheet where I want to sum up hours for a person per month. Tasks are entered on a row basis where the user enters the name in column C, hours per task for each month column H contains Jul, column H contains Aug, etc On a separate sheet I want to sum all the hours for...

I have a dataset (see sample below). What I'm looking to do is return in one cell where the highest unique count is the same for different periods. I have found the below array formula, but would prefer not use this, as the actual data will be quite large. =IFERROR(INDEX($J$8:$J$500...

Hi All, I just need a code for vlookup from another workbook, I tried a lot but's not working properly. I even tried to recorded macro but workbook name changes everytime. Actual requirement is Lookup value is in P column of Loan contract & lookup range SFDC_report.Sheets("SFDC...

Hiya, I have a workbook with two worksheets in. Worksheet one has a list of telephone numbers starting in column A2 -> A143 and in D2 -> D143 are their respective owners. The second worksheet has a list of telephone numbers with charges associated with them. I want the second worksheet to...

Hi, I have around 400 workbooks are named "1.xlsx, 2.xlsx....400.xlsx" in same folder, because they have merged cells I can't do VLOOKUP, so I need to pick this data manually by ='C:\Users\Documents\2023\Data\RawData-Mar\[1.xlsx]Sheet1'!$C$4 so, I need to file name be changed to match serial...

Could anyone help me with the formula for below problem. I need to find the item name with the maximum price in a new column against the name. Attached the excel for the reference. CDEFG1NameItem NamePriceExpected ResultFormula to be used using...

Could anyone help me with the formula for below problem. I need to find the item name with the maximum price in a new column against the name. Attached the excel for the reference. Name Item Name Price Expected Result Formula? Harry A 20 C B 67 C 87 D 87 Tom A1 25 E1...

Data dump fills out cells. In Column P the data will give the start time of certain shifts. Column AG will have a sequence of numbers 1 to whatever the total number of start times there is that day. Column AF fills out after macro is run to copy and paste the start times. Column Q returns the...

Sheet 2 has information about the sales of various products for a manufacturer "XYZ" while sheet 3 has the information about the prices of these products. Using the data in Sheet 2 and Sheet 3 answer the following questions: Q1: Using Vlookup formula, calculate the total money earned by "XYZ"...

Hello, Please help me. When I have to work on Date, I often spend a lot of time working. How to use vlookup when we have Date to consider.

Hi there, I am hoping one of you wonderful people can help me. The data within Lat! in column B has a few duplicates and I am trying to return a value from columns 34 & 49 where the date in AD is the maximum. Example data A1= 123456 Lat!B2= 123456 Lat!B3= 123456 Lat!AD2= 10/05/18 Lat!AD3=...

Hello, Actually I have to update a master google excel sheet daily with numeric values. There are thousands of names across which value to be updated daily by datewise (new date in new column). Daily I get names with num values which eventually to be entered in their respective cell of a new...

I want to Rank Top 10 Products along with figure from another sheet as below. The other sheet contains similar Products name in multiple category with the total from each category. I tried INDEX & LARGE formula, but it did not work well because Total figure would become bigger. Would appreciate...

Hello, I want to return Email IDs (C column) with respect to actual names (Column B). But I need to lookup in Username (Column A) for the Actual name keywords / Partial Match. But that Vlookup formula is not working. Is there any other method or formula that be used in this case . In short ...

Hey folks, I have a quick question. In excel if you are doing a vlook up for a value and the look up column is a range in a cell, will excel recognize it? I'm looking for an option. So if my look up value is 2 and the column array is stored as '1-3' in a cell , I'm thinking it will not...

Hello, This is my first time posting in such a forum. I'm not very good with excel but I understand the basics. I've tried looking around the internet for a fitting formula to my problem and couldn't find something specific. I need a formula that will take 2 numbers from Workbook 1 Columns A &...

Hello everyone, I want to show the status of an ID in the previous period in the same row of today's ID. The table looks similar to this A H L M ID (...) Status (...) Current period Previous Period (...) In the column next to previous period I want to show the status of...

Hello Everyone, I need small help in if and vlookup function Please find below below table for example: I want that when i apply lookup in C column it should check all raw values of same reference number in A1 or so on and give me match result. please help me A B C d E F 123 Apple...