vlookup

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. L

    Drop-down list with index(match

    Hey guys, has the website had an upgrade? Looks great! I'm trying to make a waste cost dashboard. Basically, all I want to do is select the supplier code from the drop-down list and once I enter the number of workshops run, it will automatically update the number of seats the event had space...
  6. B

    Integrate VLOOKUP in VBA

    Hello everyone, I have a workbook with two worksheets namely "1" and "Sheet1". I would like to write a macro which integrates the VLOOKUP function. My working function is as follows: =IF(H2="";"";VLOOKUP(H2;Sheet1!A:C;3;False) but I am kind of stuck with how to get it to work in VBA. In...
  7. M

    Lookup, Vlookup, Xlookup???

    I have a file that keeps track of a dollar debit and converts to a Kč (Koruna or crown) amount based on the exchange rate of the day the dollar amount was subtracted from my dollar account. The row containing this data can be seen in the attached image. I began this record-keeping in January of...
  8. C

    Shorten formula

    Hi, this is a very simple request... i know there must be another way around, but this is what i have based on my limited knowledge... please shorten this formula for me...
  9. M

    How to populate a cell value from the value of another cell

    Hi There, I have a table on a worksheet. In column C there is a list of ten different Chakras. Each Chakra has four rows in which you can select four different colours; you can choose from 14 different colours using a data validation drop down list. Once this colour is selected i would like the...
  10. S

    Vlookup can't find match

    Hi, I have a strange issue with using VLOOKUP. I have seen this before but i don't know the reason. =VLOOKUP(A10,InputSheet.csv!$A$10:$Q$99,7,FALSE) Above is the formula. all cells are set up a general. A10 is a formula pointing to another sheet. When I change the cell from a formula then it...
  11. K

    Lookup Approximate match against multiple criteria!

    Hello Everyone, I have a data table and i want to find approximate match against that table, CATEGORY DENIM DENIM NON_DENIM NON_DENIM RANGE NORMAL WASH HEAVY WASH WASH DYE 999 8.00% 12.00% 8.00% 12.00% 2,999 6.00% 8.00% 6.00% 8.00%...
  12. C

    Referencing Dim in VLOOKUP

    Hate to bump, but I'm stuck..... I posted Friday, but with 56 views, I'm the only post without a reply through Sunday, so I'll try to parse my inquiry. VLOOKUP Macro Workbook Reference Variable Range("J2").FormulaR1C1 = _ "=IFNA(VLOOKUP(RC[-5],[" & wkb3 & "]!C5:C9,5,0),"""")"...
  13. R

    Extracting PARTIAL words from cell

    I'm in a worksheet and trying to extract the words after the 3rd and 4th hyphens when they're available in column A (see table below for representation). <tbody> Digital - workbook - sheet Digital - workbook - app Digital - workbook - test Digital - workbook - sheet - max - version1...
  14. Y

    VBA INDEX MATCH Application to display value in Textbox

    I am trying to use Index Match to replace Vlookup Function so my textbox displays date format. If I use Vlookup my textbox shows numbers. I tried the below code but it is not displaying the value in the textbox once I run the code. Can I please have your help to make the code work? Dim TBL As...
  15. A

    VBA Select the excel file for your Vlookup Link

    Hello Guys. Please help me with my little Project. I have this project where i needed to link a database(Process2.excel) to another database(Process1.excel) so that it can automatically compute the offset adjustment(CNC Machinining) based from the Part ID's data from the previous process. The...
  16. C

    Improving my Formula

    Hi All ive created this formula and it works perfect, but as your see in a sec its rather big. Can anyone think of a smarter way to get the same result. The below checks to see if there is a date in the BOLDED cell and if there is it moved onto the next till it cant find a date, when it cant...
  17. S

    Consolidate multiple sheets

    Hi I am trying to consolidate multiple sheets into 1 tab. I don't know how to use the sumif because 2 of my criteria are in the same column: the customer name and the value name. I don't even know exactly what formula to use...all help would be appreciated. I am trying to consolidate data in...
  18. R

    Runtime Error 1004 - Using VLOOKUP in VBA (COMPLETED)

    Running a very basic test code to try out on a large amount of data, but having trouble, getting the "1004" error. Sub HugeSort() Dim c As Integer 'LOOPS THROUGH ALL ROWS For c = 2 To 10 If IsEmpty(ActiveSheet.Cells(c, 1)) = False Then ActiveSheet.Cells(c, 2) =...
  19. F

    VBA Vlookup help

    Im looking for a VBA code that works like Vlookup. Lookup data= A:B (D1) is a dropdown list of A:A (E1) is a manual input of a number. When the Macro is ran, I want it to search for (D1) in column A:A and increase the amount in the corresponding B:B column by the amount in (E1). <tbody> A B C...
  20. R

    VLookup and change output

    Hello. I have a vlookup function looking up American citys/towns and returning the full state name that they are located in. How can I pull in the full state's name (how the data comes in), but then have it display the abbreviated state's name. Example: Florida -> FL. LEN( doesn't always...

Some videos you may like

This Week's Hot Topics

Top