excel & lookup

  1. H

    Excel vlookup with variable information

    Helloooo, Is there a way please to lookup information from other spreadsheets based on variable information? This is quite hard to explain so I’m just going to list out what I have below and hope that someone can make sense of what I am trying to ask! So this is a little mock up of my scenario...
  2. U

    Xlookup

    Hello, Would you know when would all Excel, Office 365 users will be able to utilize the following formula: "XLOOKUP"
  3. V

    Calculate a cell value based on a specific string in a separate cell

    Hello, The first column contains a string of values as mentioned below . In 2nd column, I need to strip out specific info from Col 1 (as mentioned below). I tried using a formula like this - =LOOKUP(MID(AS2,12,3),{"Lar","X-L"," Sma"},{"Large","X-Large","Small"}) , but its not calculating the...
  4. G

    Formula/Macro Help

    <tbody> A A B 3 C M D E GENBPAPP A 3 S GENBPAMIN A 1 SE SEBPA B 1 M GENLPA B 1 A GENLPA A 3 S CU CUAMIN </tbody> Hello, I have the above table (which I hope the format sticks around) as a lookup. I have rows of data that contain values. am looking for a formula or vb logic...
  5. C

    Selecting rows that best fill a specified criteria

    I have a worksheet that lists necessary components to meet an objective and then several source inventories. I would like a way to pick the combination that best fits the needs and the combination with the fewest sources that meets the needs. <tbody> <colgroup><col><col...
  6. E

    Excel Formula Help - Thanks in advance

    Hello, I was wondering if the good natured people here at Mr Excel can maybe tell me what im trying to do is feasible or not, Basically, I have a few different formulas connected to a file on Sharepoint (just index match and vlookup) and they all work fine. here is one of them below...
  7. A

    Identify Range based on set of values

    Hi, I have set of values in column A, for e.g. 10,20,30,40,50,60,70,80,90 and 100. Now in column B I have below values 33,50,60,90 How to identify, range of values in column A based on values in column B. It should return following values : 30,40,50,60,70,80 and 90(assuming we are taking...
  8. P

    Exceptions formula

    I have a data set where I am trying to create a formula for each work order that does not have a specific task ("Task 5" Below Table) within the work order based on specific customers that must have this task with their work. There will be customers that do not apply and will not need this task...
  9. E

    How to loop though a range of cells and if it is false to skip to search the next row, rather than insert my false result

    Hello there experts, I have the following code that successfully returns the values of any cells in column A starting with a letter A to Z: =IF(AND(CODE(UPPER('PL & BS Leadsheets'!A5))>64,CODE(UPPER('PL & BS Leadsheets'!A5))<91),'PL & BS Leadsheets'!A5,0) The range in sheet 'PL & BS...
  10. A

    Index Match to replace a Vlookup

    Good day, I have a table that stores rates for NI Contributions called Rates and I have been using a Vlookup to return the Rate based on the employee Salary like this VLOOKUP(I4,'NIS AND TAX TABLE'!$E$2:$F$18,2) Now that the rates have been increased (highlighted in the Rates Table...
  11. S

    Formula to Match Text and update for same values in the row

    Hello Team, Need to look for "AA" in the Text and if so update the Yes in result , for those multiple invoices if the Text is also not equal to "AA". i have trying with below formula, but stuck: =IF(AD16="AA","Yes",IF(MATCH(J16,$J$16:$J$22,0),"Yes","No"))...
  12. N

    V look up substitute for data with multiple arguments that fall within certain timelines

    Hey there, I was wondering if somebody could help me. I have a time card data excel sheet for all restaurant workers that has their clock in & clock out time, their job title and their total hours for one particular day. For example: Time Card Sheet (Sheet 1) <tbody> Department Clock In...
  13. A

    Can someone explain how the below formula to transpose all rows to one column works?

    Hello, I have used this formula: **=INDEX( MyData,INT((ROW()-ROW( $Z$1 ))/COLUMNS( MyData ))+1,MOD(ROW()-ROW( $Z$1 ),COLUMNS( MyData ))+1)** to transpose all of my rows of data into one column. Unfortunately, I can't entirely wrap my head around how it works. Would someone be willing to...
  14. U

    VBA vlookup to Reference Sheet & Create a Pivot

    Hi Guys, I have a massive data set that needs vlook up and pivot. I have this excel file named "MasterData" with two tabs sheets namely: Master & Reference. The master contains a list of data while reference sheet has list of countries and its equivalent country group. Example Reference...
  15. F

    Match Stock Prices with Stock Splits VBA

    Greetings (first post and I am in need of help)! I am writing some VBA and here is what I would like to do but I am having difficulty creating the structure. I have a list of daily stock prices for multiple companies, although the stock prices do not indicate that they went through a stock...
  16. A

    Formula not finding answer

    Hi everyone, I have a problem with a excel sheet, I am using both for inventory purposes. I download the new inventory and have to input the new value so that the shop will have the right inventory count. The problem is that the formula is not recognizing the value from the new sheet. Even...
  17. O

    3 way lookup excel table help

    Hello, I apologize if a similar question was already posted but I couldn't find one. Sample table shown below, the real table is much larger but same general format. I am reading in a given value off a different sheet that corresponds to a labeled name in column A. Based on this, I am trying to...
  18. I

    Best formula to compare 2 fields in a multi tab Excel Workbook

    Hi All, My first post so please be kind to me :) My question is a straightforward one, however there a a few complexities I need to work out. I am trying to do a compare on 2 cells to see if the same text exists in both, now this is my problem, the cells are on different tabs, I would also...

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top