lookups

  1. Z

    How to have VBA to perform vlookups when command button is clicked

    How can I get VBA to perform a vlookup in a range of cells. Right now I have this formulas in cells like below. Cell A8 = IF(C8>"",VLOOKUP($A$7,'Employee Data'!$B$4:$D$27,2,0),"") Cell A9 = IF(C9>"",VLOOKUP($A$7,'Employee Data'!$B$4:$D$27,2,0),"") Cell A10 = IF(C10>"",VLOOKUP($A$7,'Employee...
  2. K

    Vlookup/Hlookup need help

    Hello, I have GL data that basically looks like this A1:GL Acct # B1: Name C1: Total D1: Department 1 E1: Department 2 F1: Department 3 A2: 65000 B2: Wages C2: 1,000,000 D2: 500,000 E2: 250,000 F2: 250000 A3: 79000 B3: Travel C3...
  3. L

    How to get in which range a value lies out of multiple ranges

    I have a value e.g 48 There are multiple ranges, and each range will correspond to a specific amount, example below: 11 to 20 --> 15 21 to 30 --> 25 31 to 40 --> 35 41 to 50 --> 45 I want to search for the value 45, so i need to check the multiple ranges to get that specific value on the...
  4. W

    Multiple vlookups for different tables

    Hi, I am trying to use several tables in an if formula but I haven't gotten it to work. I have one master table which I want to look up to first, however, if the lookup value contains City (Suburb), City2(Suburb) or City3 (Suburb) I want to look up from three different lookups tables. I have 4...
  5. M

    Can you have dropdowns in Excel Data Form?

    I am using Excel Data Form to make it easier for leadership to see and/or modify the data within it and also add records. Problem is the actual table has several columns that are doing lookups, but the data form does not give me the ability to perform those same lookups, so its all manually...
  6. S

    Summarising a calendars events with lookups and ifs

    Hi all, I am trying to create a summary of a sort of calendar I have made. The calendar is a daily view and runs landscape, with the days/dates (custom formatted to just show the day i.e. d) at the top and then with the task/meeting categories to the left of this (column A). I want to summarise...
  7. M

    Macro paste values in current row when text changes

    Hi, I need a VBA/Macro for disabling lookups in the current row of column D when text changes to "Today" . For example, I have 100 rows and 5 columns in my sheet, in column 4 (D) if the cell shows "Today" I want the entire rows lookups to be disable or paste values to stop the lookups. Thank...
  8. C

    Macro to Select file location for lookups

    Morning All, I'm not sure if this is possible but was hoping you could tell me. I need to write a macro that does lots of lookups and others things by comparing two spreadsheets. The spreadsheet that is being used as the lookup will have a different file name each time it is run. It is...
  9. L

    Macro to print a changing report based on lookups

    I have a different report to print for 80 individuals based on lookups - I am using a single unique identifier to change the data on the report (G1). Here is my very weak macro attempt but it only prints the for first person on the list. How do I make this loop to print the next report and so...
  10. J

    Macro to speed up index/match

    Hi, I have an Excel worksheet that has to do an index/match to look up data from another sheet. It has 14 rows and ~8,000 columns -- each with an index/match. So, as you can imagine, the file is huge (60 MB) and too slow to be usable. I'm thinking I could instead have a macro do the lookups...
  11. L

    Create worksheet tabs from a range of cells but do NOT create duplicates

    I have a spreadsheet with multiple part numbers and in many cases, duplicate part numbers. There are 10,000 rows! <tbody> F G AO 1 000746-A-1 REV H <tbody> 000746-A-1 REV H OP-10 </tbody> <tbody> SHEAR 1st PC FOR INSPECTION Use 14 Gage (.075") 304SS, Shear strip to 3.25"Wide Move to...
  12. S

    VLOOKUP, INDEX, MATCH... What do I use for this scenario?

    I have two separate workbooks that include one spreadsheet of data each. One is a lists of all of our B2B customer information - Customer ID, Business Name, Individual Name, and Email Address. We will call this spreadsheet Customer Data. The second spreadsheet, located in a different workbook...
  13. O

    INDEX/MATCH with Infinite possibilites

    Hi, Was not sure what to name the topic to best describe this. I have an INDEX, MATCH formula that looks up a list of categories to return a response time based on the category. This works fine. However I have an issue that if a person can't be allocated into a category, it automatically uses...
  14. P

    How to use Excel Solver with lookups?

    Is there a way to use the solver with the data shown below? I want to have the Solver Table (Columns F-I) pull the data (Columns A-D) with the following constraints. 1) Maximize the sum of the profit (Column H), 2) Keep the sum of the Lbs <= 300 (Column I), 3) Each type must include two...
  15. S

    Setting out data and or multiple ranges with Multiple lookups.

    Hi all, I have hit a dead end and am in need of some help. Apologies in advance as this scenario is slightly lengthy I want to ensure that you all have the full information. The data that comes out of the accounting system is raw data dumps from 2 SQL data tables, one gives me all the purchase...
  16. A

    Probably need to use OFFSET but am not sure

    Hi I had some answers to a post a couple of weeks ago which were amazing, and have solved that problem. But the person I was doing it for has asked for one step further. Old post is here (I still can't figure out how to do the attachment thing - have tried all of them - might be because I'm...
  17. L

    if, lookups, checking if a cell value exists within another col, if so return value NEXT to that cell

    I have two columns of dates and one column with prices. The first column is a day by day sequence across the year (365 cells). The second column are the days when a transaction occurred (eg. 100 cells) and the third column is the transaction price on those days (100 cells). I want to plot the...
  18. ClimoC

    Array SumProduct Average?

    Hi again all Not sure where to start with this one, so I'll try to keep it brief. We have two sets of cells on separate rows that contain lookups to a separate table for each row. These return some decimal values. <tbody> Name1 Name2 Name3 Name4 Name5 Table1 Lookup 1.02 1.12 1.3 0.89 0.91...
  19. A

    Taking Data from one tab, looking up another tab and pasting a row in

    Hi, I ned to keep a record of stock sold each week in a sportstoreI have two tabs. One called "Weekly Update" and the other called "All Stock". All Columns are named and formatted the exact same on both tabs. I need to do a Weekly update of stock sold on the first tab. This has 7 Columns and...
  20. L

    HELP! is there a quick way to count / lookup

    Hello I have a dataset with about 200 different post codes spread across 6,000 company names. I want to find out how many companies are in each post code. how should i do it? hopefully, my end product is a bell curve distribution chart..

Some videos you may like

This Week's Hot Topics

Top