lookup

  1. J

    Look up a value for which 2 pre-conditions need to be met (ID and Year)

    How can I look-up the share (Column G) for the needed ID and the corresponding year? See attachement.
  2. R

    Fancy lookup required! :)

    Hi, I need a formula that can identify when the Employee in column A leaves the business. This can be seen from the -1 in the respective months. For example Employee 1 leaves the business in P03. This is populated below the data and this is where I'd like the formula to work from if possible...
  3. M

    Lookup across multiple columns

    Hello I'm new to the forum and look forward to your insights I have the weight band in column D and want to look up the prices in columns E to J how do I return the right price for each row? See below <tbody> Weight (lbs) Weight Band A B C D E F 167 A 156.53 126.79 107.98 90.78 78.94...
  4. S

    Lookup query

    Hi. In Sheet0 I have columns A to O populated with travel data. E contains email address I contains departure date L contains country B has the formula =IF(COUNTIFS(TA!C:C,E2,TA!E:E,"*"&L2&"*",TA!D:D,"<="&I2+7,TA!D:D,">="&I2-7)>0,"yes","no") which looks to see if there is a corresponding value...
  5. S

    Lookup text between 2 dates - is it possible?

    Hi, im trying to list/extract all the text from Z16:Z116 when another columns date falls between a start and end date. Z16:Z116 = text to extract AV16:AV116 = contains date A1 = start date C1 = end date is this possible?, I've tried Lookup & Index formula I have found on forums without...
  6. D

    #N/A error with Lookup and Min functions

    Good Afternoon everyone, I have run into an issue using Lookup with Min. I can use Lookup with Max and get the required results, =LOOKUP(MAX(E7:E1000),E7:E1000,D7:D1000) actually gives the date that matches the Max value. When I change the formula to =LOOKUP(MIN(E7:E1000),E7:E1000,D7:D1000), it...
  7. M

    Lookup Function

    will someone help me to convert the following formula in access. LOOKUP(2,1/((SEARCH($D$1&"*",BOM!$I$88:$I$2617))*(BOM!$C$88:$C$2617=Sheet6!A6)),BOM!$D$88:$D$2617),"") Thanks in advnce
  8. B

    Sumif using a list of criteria

    I was wondering if there was a formula that I could use to sum a data file using the below columns as the lookup, I would also like to use another criteria in addition to this. I.e If any of the numbers in column A appears in raw data file, sum the respective number in another column...
  9. Y

    Lookup between alphanumeric range?

    Hello, Probably being thick here and the obvious answer is alluding me but I need a formula to return a value based on where something is between a range of alphanumeric characters. At a basic level something like the below: <tbody> Start Location End Location Who A001 A100 MT A101 A200...
  10. C

    VLookup within a macro?

    Hi Excel geniuses, I'm looking for a macro which will effectively do a VLOOKUP, but where the lookup array is in the macro itself. Basically I have stand alone csv file, the users of which won't have access to a shared folder in which the lookup table can be stored. In one column I have a...
  11. O

    Vlookup with variable lookup value

    Hello, Is it possible for a VLOOKUP to have a multiple lookup value. For example: =VLOOKUP(A1,'Data'!$A$1:$D$1000,2,FALSE) If the lookup value in A1 is empty it can look at a different lookup value in A2? Thanks in advance, Chris
  12. J

    Explanation

    Hello, Can someone help me understand this array formula. I found it online. It returns the value in the last occupied cell in a row but I would like to understand how the middle section works. My understanding is that ($T14:$HK14<>"") is FALSE, so what does dividing 1 by FALSE work. If...
  13. A

    Populate cell value based on a lookup & match from two other tabs

    Hello, I am fairly novice to using excel, and have searched for my answer but am running low on time to find an answer, so figured I would just post to see if I can get a speedier answer. Below is an explanation of what I am trying to do. I have two tabs in a workbook with some of the same...
  14. N

    using vba or excel find the first reference match

    hi guys, i would like to ask how can i resolve this..... Below is my actual data. date time temp 1 10/7/2019 0:12 120.3 2 10/7/2019 0:13 119.5 3 10/7/2019 0:13 121.3 4 10/7/2019 0:13 120 5 10/7/2019 0:13 121.2 6...
  15. D

    Excel Lookup and SUMIF to data on Different Workbook **Help Please**

    Hi, I wonder if anyone could help as I have been wracking my brains. I have set up a fomula to lookup against data on a different tab on the SAME workbook. Example below - this lookups the tab number noted on cell D21 of the current sheet, finds the 2nd column (column B) against the lookup...
  16. Z

    cell value format

    Hello, i'm using the below table to track monthly sales, i inserted a slicer with the data in order to auto filter based on my selection, in the lookup column (index formula & slicer used) i cant or don't know how to get (Quantity-Amount or %) with its cell format, example: if i want to select...
  17. L

    Find related items based on multiple criteria > index+match multiple criteria or somthing else?

    Hi all, This is a challenge, at least for me. What I'm trying to achieve is the following: I've a big list of items with several specs. I want to project the matching items (with the same specs) in columns after the item to match. Simplified example of the data: <tbody> Item Spec 1 Spec 2...
  18. smide

    Return the second to last value - data in two columns

    Hello. In columns A and B (A1:A600 and B1:B600) I have product names and in columns C and D their prices. When product is in column A his price is in column C (same row) and when product is in column B his price is in column D. In column E I have a list of all products (E1:E50). With array...
  19. C

    Find matching value in another sheet

    I have a list of data split across 2 sheets. On sheet 1 I want to type in a value into column E and if the same value is present in Column E on sheet 2 then it copies cell value on the same line in column C and pastes it in column J on sheet 1. Not sure if this is a lookup that's required...
  20. D

    lookup initial entry in multiple transfers

    Hi, I have two columns with Entry no and TRansferred from entry no and would need to calculate a column Expected initial Entry no, that brings the initial entry no if an item has transferred ( it's differnt than zero). It is easy to bring the value if we have one transfer for example entry 2...

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top