vlookup + index + match

I have two excel files, one is file named data and other one is flile named format. The data file has multiple sheet named as "north" ,"south" and "west", each of these sheets have a reference column containing values a, b,c,d,e as values of first column and dates from Nov 4 to Nov 10 as values...

I am looking for a more sophisticated query to compare values of a column in a sheet against multiple sheets and if the value is found return values from a different column. I was able to achieve this with iferror and vlookup but i have about 20 sheets to compare values against. Sheet1...

Hello, I'm looking for an Excel Formula and I hope that someone can help me out with this? I tried to draw a simplified version of the Excel below. I'm looking for a dynamic formula which returns the required training level for a specific Team. For example: - For Team C - For Training 6 -->...

Hi, I have a problem with table below. I need to learn what formula to use so that I can get correct answer to Solution X. I added into the table what I need for answer into Solution X column. User1, Info2-3 varies depending if users fill it or not. Solution X needs to be same in all lines...

Hi Everyone, If you’re reading this, thank you. BACKGROUND My role at my company requires of me to report the most currentprices stored in our databases. Sometimes I get requests to pull prices forproducts that first billed several quarters ago. The challenge with this is thefact that the price...

Hi I have 2 suppliers, Anglian and Sarqusa and we buy some of the items from both suppliers and want to find out which items that we buy from the secondary supplier (Sarqusan) we use. Columns A to C is the main excel I use with our main suppliers like Anglian. Then I have another report with...

I'm looking for a function to populate column 'Hold1'. If a value in Ref2 is present in Ref1, then populate Hold1 with the corresponding value in Hold2 <tbody> Ref1 Hold1 Ref2 Hold2 15 5 35 21 23 2 58 56 16 23 15 9 2 87 25 10 60 1 89 65 13 95 34 65...

I’m trying to do something that I thought would be relatively simple but turns out to be more complicated than I thought and I am stuck. I have two sheets with data and need to do the following: Look up an email address located in sheet one (column E), find the email in the second sheet (column...

I have a file with all the state and cities that I need. I want to match the population of the US census dataset to the cities in my list but the cities are not in the same format. This task would be easy if there weren't multiple cities that show up in different state. What I want the formula...

Hello, I am working on a spreadsheet that has the following setup. What would be the best way to find out which projects each person is on? I was thinking of doing a vlookup, but I would like to know if there is a better alternative. <tbody> Project Resource 1 Resource 2 Resource 3...

Hello everyone, I am a little stumped at this point and I have tried multiple things (maybe I need some coffee lol). So I am building an attendance sheet for my company to use across the network. I am trying to make it more user friendly. We use a point system when it comes to attendance. I am...

Hi, In my excel, i have two sheets. in sheet1, i have three columns with almost 3000 rows. in sheet2, i have two columns with 230 rows. sheet2 was like a child sheet, all these data exists in sheet one. i need to exclude non matching data from sheet one. the condition i have is, two...

Hi, I am currently working on returning multiple values from large excel data base. The headers of data from A1 to J1 - Figure- Gross - Net - Exchange -Amount - Transaction id - Ref. id- Recipient - Date - Type And all these containing the data upto 400 rows. The header FIGURE contains data...

Hey guys Firstimer here! Woohoo! I got an interesting problem. What I am trying is to do create a formula for which VLOOKUP will use column A in Exhibit 1, vlookup the info from Exhibit 2 and return the value in column B Exhibit 2. There is an extra vlookup that will use the contract number...

I have a sheet with a bunch of data that I'd like to pull the vendor addresses from and have them automatically imported into into a separate sheet. I'd like to use the vendor ID and or Vendor Name in order to pull the addresses over to the other sheet as a cross reference. Could anyone get me...

I am trying to compare current and history data to find out if number field is matching. Currently, there are columns A through AM. However, the combination of S, T, U columns makes a unique row. So I want to compare that combination to sheet2(history data) to find out if column Z is matching to...

<tbody> Cubic Local $ Outer Area $ ShortHaul $ Longhaul $ InterIsland $ 0.003 2.00 4.00 6.00 8.00 10.00 0.005 2.20 4.40 6.60 8.80 11.00 0.008 2.40 4.80 7.20 9.60 12.00 0.01 2.60 5.20 7.80 10.40 13.00 0.012 2.80 5.60 8.40 11.20 14.00 0.016 3.00 6.00 9.00 12.00 15.00 0.02 3.20 6.40...

In simple terms, I am trying to do this: If TEXT in Sheet3!A2 equal TEXT in Sheet2!C:C and if TIME in Sheet3!D2 is within TIMES in Sheet2!I:I and Sheet2!J:J return TEXT in Sheet2!O:O I was able to build a formula that returns the TEXT in Sheet2!O:O however the time has to be exact and I am only...

Hi folks, I am stuck and am hoping you can help. I have given up on budgeting software and am attempting my own Excel version of a budget for my household. In a worksheet, I have downloaded all of our bank activity for the year. Many of the transactions are repetitive, but the bank reference...

Hi, Its 4 part question, just want to start with part 1: Here is what I badly need: 1. Lookup Pre Production Data's Product ID in Post Production Data 2. Check all Parts IDs data, if any of the Part Code has changed 3. If YES, insert "Upgraded" in Status column and if not changed than insert...