vlookup

  1. 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...
  2. 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...
  3. 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%...
  4. 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),"""")"...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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) =...
  11. 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...
  12. 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...
  13. J

    VLOOKUP vs. INDEX/MATCH on variant array

    I have a multidimensional array with 'x' rows and 3 columns of data, and I'd like to perform a VLOOKUP on the array information stored in memory rather than calling the worksheet each time. I'm just not sure how to write the code to perform the VLOOKUP using INDEX/MATCH, and repeat that process...
  14. P

    Vlookup on multiple columns

    I have a table of courses with the name of the student. Then I have another table that I am trying to get a Yes or No value based on if they took the class. I believe I need a vlookup function, but I am missing how to get that data. Student Course Tom Smith Math 101 Jerry...
  15. J

    Grouping based on a condition

    So, I have a list of Yes/No questions and what I am trying to do is create a string of the terms that have a Y beside them. For example in the data below, I would like the cell to return Agitated, Angry, Depressed and I will reference that in a different part of a sheet. I would like for this...
  16. C

    Find Values in a Column with VLOOKUPS in It

    Hi All, I have a column that has 1,000 rows in it. Each cell in the column has a VLOOKUP function in it. When I search in that column I get an error telling me it can't find what I'm looking for. For example if "Sales" was the result of one of the VLOOKUPS in the column and I do a Control F and...
  17. P

    Sorting referenced column and rows

    Hi Guys, i have a unique problem I cannot find a solution for. Need help, I have a tabel where the first column is a VLOOKUP column from a list of names. Subsequent columns are input data with no formulas. Now, If I add a name to the name list, it shows up in the first column, but, obviously...
  18. S

    2 sheets, Connect 2 formulas, Vlookup and Concatenate

    Hi Great minds. Greetings. I have a file with 2 sheets Values for example: <tbody> Sheet 1 Code Product Type Colour sd123 Necklace Oxidized Black hf32 Bangles Gold Rose Gold </tbody> If we input a code from sheet 1 to sheet 2 manually, we would like to get the following result...
  19. C

    Vlookup Indirect Match function error

    Hi all, I am in a major pickle at the moment :eeek: Help! I would like the formula to find the pricing across multiple tabs and the problem is the pricing column. The pricing column is situated on a different column letter and row number on each tab: Please see the link below for the...
  20. M

    VLOOKUP using hidden/filtered data

    I have a list of prices, products, customers, etc. that are in categories (Beef, Chicken, etc.) and in subsets (Salisbury, Ground, Raw, etc.). I am using the Aggregate function to determine the lowest price. Then, I use the VLOOKUP function to search that lowest price for who is purchasing...

Some videos you may like

This Week's Hot Topics

Top