vlookup & data validation

  1. H

    Vlookup to provide multiple results for 1 option

    Hi all, Newbie with Excel and looking to create a dispatch database. I was told Vlookup was the function of choice. See table below: What I want to do is have a 3 colums to the left of this hidden data with CITY, PRIMARY & 2NDARY as headers. A1 - City & Then B1 & C1 will provide the details...
  2. J

    VLOOKUP using two different columns

    Hello all, I am trying to set up a worksheet that pulls information from another sheet. On sheet one I have columns starting with a date column (COL A). I am trying to get information from a second column (COL AA) to return to the second worksheet. However, the data in COL AA is not...
  3. H

    How to use logical formula and retun back an array instead of just 1 cell

    Hello experienced and talented Excel people. Example. I am working for a company and I have segments, brands and variants. Example: Segment:Coffee, tea, chocolate Brands: coffee--> Nescafe, ground coffee Tea --> green tea, freshly cut leaf Chocolate ---> white, dark, 100 cocoa Variants...
  4. A

    Data Valadate and vlookup/offset/Index help

    What I have: Sheet 1 has a list of tank_id's (no duplicates) called "Details" (Columns are Tank_id, Tank_Name, Nation, Turret, TArmor_front, TArmor_rear, TView_range..). Sheet 2 has a list of Turrets and the specifications called "Turrets". (Columns are: Tank_id, Turret_id, Turret_Name...
  5. M

    VLOOKUP wild card matches

    Hi there, I am stuck and maybe VLOOKUP is not the way to go at all but here is what I am trying to do. I have a column where uses paste data ex: HP LaserJet 4014n Printer I want to update this data with the Correct Product name from a different tab in the sheet. Table_Array 'Price List Jan...
  6. D

    V-Lookup, Match, Index combo for project status look up

    Hi Excel Nation, I am currently working with 2 lists of data on 2 separate worksheets. By using the project ID numbers and the phase specified by the corresponding column, I am trying to return the status of the phases' QA status. For the below example, I want to return the status of the...
  7. H

    Excel Vlookup or MATCH Comparison Between Multiple Sheets

    Hi Guys, Does anyone know how I can lookup the values in one row in sheet 2 (see tables below) and compare this with all rows in sheet 1? If any of the cell values in one row in sheet 2 equal the values in any of the rows in sheet 1 then I would like to return the values 'TRUE' or 'FALSE' for...
  8. M

    Help please with vlookup or index match

    I AM TRYING TO USE VLOOK UP OR ANY OTHER FORMULA THAT WOULD WORK WITH MY APPROACH. FORMULA WILL LOOK UP THE DATE FROM MULTIPLE TABLES AND POPULATE 1ST AND 2ND VALUES FOR THE CATEGORiES BASED THE DATE VALIDATION NOTE IT WILL GO TO THE NEXT VALID DATE SEE EXAMPLE BELOW I AM SORRY IF I AM NOT...
  9. N

    Formula Needed for: FIND "YES" and Return in same cell as YES

    Hi MrExcel Community, See below for a sample of data that I need to extract information into a searchable database. All of the information is provided in both columns and rows. I'd like to create TABLE 1 into TABLE 2. What's most frustrating is identifying project type by finding the YES and...
  10. D

    Copying and inserting multiple rows between spreadsheets

    I have 2 spreadsheets; the master has the server name and details as a distinct row. The other has all the applications on that server as multiple rows. I want to copy the multiple applications to the master spreadsheet by inserting a new row for each application and pasting that into the...
  11. B

    Find multiple instances

    Hi, this is driving me nuts. I want lookup 1 record-Op Number from a sheet and combine multiple instances onto the next sheet. Tried using Vlookup but only returns the first instance. Example: <tbody> <tbody> Op Num </tbody><colgroup><col></colgroup> ID <tbody> 2TT3...
  12. ladyday

    Peform a vlookup using 3 conditions (non-numerical)...

    Hi, I need assistance performing a vlook up in a table where I would like the formula to look at the data in Sheet 1, Columns A & B and if they match the information in Sheet 2, Columns A & B (same data) go back to Sheet 1 and look at the status of Column C and return a value of Y for pass or N...
  13. K

    Compare cells in 2 columns in separate WBs and return data in Col 38-40 if there is match

    Hi I am attempting to compare 2 columns in separate workbooks, and if a match is found, to return the data in columns 38-40 from one workbook into columns 38-40 of the second workbook. I thought the best way to do this was to progressively loop through the values of the column in WB1, and...
  14. M

    Problem with variable VLOOKUP value

    First off thanks for the help I'm trying to use a variable for the VLOOKUP value. The below code works however it adds parenthesis around the VLOOKUP value, the result is it's not being recognized as a cell location. I have tried changing the variable types but have not had any luck. This is an...
  15. V

    Auto populating data from Drop Down while referencing other sheets in the Workbook

    We have data pertaining to the amount and order we have recieved segregated based on location and mediums like Website and Facebook. I am building a summary sheets that will display selected information from the other sheet for a particular location. I tried using VlookUp but that does not...
  16. O

    Cell to return month

    Help...!!!!! I'm needing a formula which will paste text into a cell if another cell is between two set dates. For or example if A1 is between 2/4/15 and 12/5/15 A2 to show April if A1 is between 13/5/15 and 10/6/15 I'd need A2 to show May... And so on. I'd love to be to just format the...
  17. M

    VLookup question to match dates in Col_index_num between two workbooks

    Hello all - First post, so please bear with me. I am trying to write a VLookup formula as part of a cash forecast I am setting up. I am looking to pull daily bank balances (kept in a separate workbook) into my forecast for an opening cash position. I can reference the Col_Index_Num and...
  18. A

    VLOOKUP IF AND Function - Need Help

    I need to pull data from 4 columns for ticket sales. The columns include: - Date of Purchase - Amount Paid - Event Date - Payment Method I am trying to pull the amount paid based on the event date, date of purchase, and payment method to create general journal entries. For example - I need to...
  19. F

    VLOOKUP Code For Using Multiple Variations Of Original Number

    I have an attendance sheet that we will be using a barcode scanner to enter their invitation as they arrive. The data I was given works fine with the following =IF(B2="","",VLOOKUP(B2,'NAME LIST'!$A$2:$B$3000,2,FALSE)) With <tbody> *00361428* </tbody> As my barcode format the...
  20. J

    Validation data across 5+ columns with multiple variables within each column

    I am trying to develop a rather robust engineering/architectural style hardware schedule using Excel and data validation tables. Due to the numerous options though, I feel that data validation tables will require far more maintenance than the benefit of developing this project. To work as well...

Some videos you may like

This Week's Hot Topics

Top