vlookup

  1. M

    VLookup only if Conditions meet

    Hi All, I am trying to achieve a simple logic. Tried to search over google and forum before asking but couldn't get anyway near. I am currently using below formula which is working fine but need to manually delete extra rows to obtain conditions. (In Table) =IFERROR(VLOOKUP([@[Mobile...
  2. L

    Returning cost?

    Hi everyone, Perhaps not drinking water is affecting me or this is just a formula I've not learned yet! I'm trying to begin my journey into learning PowerBI and with that I'm reworking an existing spreadsheet to be PowerBi uploading friendly. I'll try to explain this simply: I have different...
  3. B

    Massive Data VLookup Spanning Multiple Ranges

    Hello. Looking for a solution to the below. I basically have a user-input file where the ID that the user enters should retrieve 3 pieces of data relevant to that ID with a VLOOKUP. The problem is that the data source is very large. I've put all the data on one excel tab, thinking that would...
  4. A

    Vlookup with OneDrive not working

    My question is: I use VLOOKUP all the time in Excel and am very good at it. I am being forced to start using Excel on-line with OneDrive and, major issues. I can’t figure out how to reference the Table_Array. I have two spreadsheets, Book1 [where the formula will go] and Book2 [where the...
  5. H

    Vlookup Max Value

    Hello, I am trying to look up the Max Value (Paid Rate) from one sheet and return it to another sheet. I have employees that are paid at a Base Rate, but sometimes are paid at a different rate. On 'Orig' Tab there can be a lot of Rows for employees and I need to find the MAX Paid Rate in Column...
  6. I

    VBA - INdex Match Multiple results

    0 I have two sheets (As Diplayed Below). Sheet 1 or INformation is where i have all of my information Stored. And Sheet 2 is where i want it displayed based on the Urgency (Tab Selection). Please can someone help me with a VBA code which can load this data on each of the Sections on Sheet 2...
  7. C

    returning elo calculations from one sheet to another

    Hi everyone, I am quite new to excel and have stumbled upon a problem. Namely I have a document where on one sheet (see 1.png) I have a table with teams and their elo values, while on the other sheet (see 2.png) I have data from a certain period that is then converted to an elo change for a...
  8. K

    Auto Populating a Date Text box with the latest date depending on the combo box selection

    Hello Experts, I am quite novice to VBA and still learning. So, any help from you would be highly appreciated. I have an excel sheet (Sheet 4) with Machine codes (Column A) and Service Dates (Column B). Same machine code can be repeated in column A, but always with a unique service date. In my...
  9. D

    vlookup with multiple rows returned?

    is there a way to return multiple lookup rows when searching for values from one workbook to another? i have the following in the first workbook and its the values to be return from the next sheet base on IP IP 10.10.10.4 is found three times (this is workbook A) a b c client name ip...
  10. C

    Copying data from one workbook to another. Multiple columns and rows to copy and add to values already present...

    Hi all, Not sure what I am doing here... I am trying to figure out how to copy data from one workbook (single sheet) to another workbook (1 sheet). The problem is that I have 5 columns of data on the source sheet, and multiple rows of data to copy. The column header is a date and the row data is...
  11. T

    VLOOKUP OFFSET 1-10th row

    Hi there, Im trying to create a formula to look up the 1st, 2nd 3rd... occurences off "CHUCKER" using vlookup heres my formula for the first row: =VLOOKUP("CHUCKER",'[1 (version 1).xlsb]Pivot'!$1:$1048576,2,FALSE) anyone know the formula to return the 2nd and 3rd occurences? Any help would be...
  12. A

    Partial Vlookup

    Hi I have been trying to figure our how to vlookup using partial of text but I cant seems to figure it out. This would be a example: (also attached as image) Need Return Value Column array 22030 Fairfax Tim 54862 Georgia Cool 12345 Super City Dog 22120 Centreville Peter...
  13. R

    Return value based on multiple conditions

    Hi everyone I'm trying to return a value based on multiple conditions. The first condition is that the date is either equal to or between to dates. The second condition is that a specific cell in the same row that fulfills condition 1, has a value larger than 0. Please see the attached...
  14. D

    Array or Vlookup?

    Good Afternoon! Sheet1 a b Os Type 1 aix svr 2 printer svr 3 windows 8.1 ws Sheet2 a b...
  15. S

    Multiple Cell Check without VBA

    Hi, I have an hard time being able to figure out a solution to my issue and would like to see if anyone can help or has ideas of how this challenge can be resolved. I am trying to find a formula that is able to tell me if a cell has changed from a number to a text (horizontally) resulting in...
  16. S

    conditional formatting in vlookup

    conditional formatting is reading the text in vlookup and changing colour it should not happen. =IFERROR(IF($B7>0,VLOOKUP($B7,DATA_BASE!$A$2:$B$100000,2,FALSE),""),"NOT FOUND IN DATABASE") Range("J2").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection...
  17. C

    Pull data from external workbook to active workbook based on a specific cell value

    Hey guys, I'm in somewhat of a pickle. I have two workbooks, the first lets call "tool.xlsm" and the other "hours.xlsx", what i am trying to do is within "tool" the user will input a value in cell Q9 and from there I need to run a macro to take that value and search that value in "hours" by...
  18. E

    Summing all instances of a VLOOKUP Formula

    It seems so easy but stumped! Here is the formula: =IFERROR(IF(F14="Basic", VLOOKUP(E14,'DAI Obligations'!$K$1:$AV$367,30, FALSE), 0),0) If Cell F14 is "Basic", it picks up the Requisition Number in Cell E14 and finds a match in the DAI Obligation worksheet and brings back the number in...
  19. N

    I have excel sheet with data as attached screenshot. Data is in three column - Keyword, Search volume, competitor.

    Hello Everyone, I have excel sheet with data as attached screenshot. Data is in three column - Keyword, Search volume, competitor. "Keyword" column has every two values are same but their values in "search volume" & "competitor" are different or same. I want only one keyword in every two same...
  20. B

    First & Last Times

    Hi, I'm working on developing a spreadsheet which tracks how many hours each employee is in the building for per day. I have a download from our clock in system which provides me with the employee name, dates and times they use their card to enter/leave the building. Because people are in/out...

Some videos you may like

This Week's Hot Topics

Top