excel & lookup & search

  1. L

    kindly help to find hours as per given format

    dear sir ma'am <colgroup><col><col><col></colgroup><tbody> ORDER ID NO OF HOURS TO PICK OR3173JG-002A 90 OR3289CG-002A 71 OR7846FG-002A 87 OR5531NF-003A 24 OR8259UG-001A 99 OR9663UG-001A 77 OR4926VG-001A 69 OR4421UG-001A 90 OR3805DF-002A 91 OR8570UG-001A 5...
  2. Nayasoch

    How to extract text strings of only cell starting with specific character

    Hello Everyone, I have searched for solution for few hours but couldn't find any. I have few text strings of variable length. I would like to extract content of cell that starts with certain specific Character. For Example I have A1:A3 Batman vs superman 4:50 Wonder woman vs Flash 5:60 Batman...
  3. M

    How to match with it. Vlookup is not giving exact details.

    Hello, Please have a look into the below two table. . and assume that 1st one is posting data and 2nd one applied data. I have to verify whether all the posting data are applied or not. If we use Vlookup or Duplicate formula that $2000 will show as applied but i have applied two only. one of...
  4. L

    Time Study Audit Based on Range of Employees

    A colleague is trying to do a time study on how long it should take to hire a new associate. Their spreadsheet data is below. I need to enter a formula C1 to predict the amount of time it would take to hire a group of associates. We assume that 1-3 associates takes the same amount of time, and...
  5. S

    Vlookup does not copy/paste or drag

    I keep getting the #REF when i copy this vlookup down and have no reason why. Please help, the sheet and cells it is referencing is =IFERROR(VLOOKUP(A16,'Locked Forecasts-DNT'!A2:AI1048576,35,0),"-"), usually works when i manually type it but can't do it any other way. thanks...
  6. M

    Help for excel formula; find duplicate names and then find most recent date

    Hello there and I require some help to build an excel formula. Situation: I have a column A with names and a column B with dates. In my table there are entries with the exact same name, but of those with different entry dates. I want in column C to identify for each row name duplicates and...
  7. 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...
  8. C

    excel partial match in any of the lookup data

    I have data in column A and B have lookup data. If the any of the lookup data is partially matching in the result column need to put lookup data. I tried with VLOOKUP but no luck. Please help me. Columns: A B(Lookup)...
  9. A

    Using VLOOKUP to list values that contain a smaller value

    I have account codes that look like this #######-###-##-######. After the first (-) ###, is the department code. In sheet "acct_codes" all of the full account codes are listed and in sheet "dept_list" all of the departments are listed. I have a sheet called "lookup", in cell B2 of that sheet...
  10. R

    Search unique value dependent on different column

    First time posting.. I have a large data set with three columns: Date purchased, Item, and Transaction id. The transaction id can have multiple items for the same transaction id. I want to search how many times different item combinations repeat for each transaction id. I.e. I want to count...
  11. N

    Find and Replace List

    Help Please, I know this has been answered a number of times already, but I don’t know enough <acronym title="visual basic for applications">VBA</acronym> to interpret the code and manipulate it to meet my specific needs. Basically, I need to update old account information with new account...
  12. K

    automate website search and extract data to excel sheet

    Hi All, I need help and suggestions: I had a list of contacts and their details its a bulk. I need to verify those names and contact details are matching with my database site or not. In detail my database site user interface have search option if I give name of person with id he have if it...
  13. F

    Automatic select, copy and paste

    I am wondering if there is a way to search for a specific value in a column; then if the value is found highlight the entire row and copy it to another sheet or workbook. I know that you can do this manually, I was just curious if there was a way or writing a line of code or a string of macros...
  14. A

    last working day of the month

    <tbody> Hi All while calculating the average balance for my working I need to use the last working day of the month, however If the month end does not fall on the last working day, the average balance is not correct. For example, if 29th is the last working day of a 31-day month, the average...
  15. O

    Find cell value based on multiple criteria

    I have a table that contains productid and price date. The price has gone through changes overtime and need to find the price value based on specific date but the this specific date fall between a range of dates. Here is my work table: <tbody> <tbody> Product ID Price Date Need price...
  16. Q

    IF > 0 THEN return corresponding Column & Row Header; for times the value occurred on each date

    I' have a question somewhat similar to this post, but with some difference. https://www.mrexcel.com/forum/excel-questions/703080-find-value-table-return-column-header-row-header-each-occurrence.html <tbody> 01-JAN-17 02-JAN-17 03-JAN-17 04-JAN-17 05-JAN-17 06-JAN-17 07-JAN-17 99XX1002 0 1...
  17. N

    Updating multiple workbooks at once

    Hi All, I am currently handling multiple excel workbooks that each have a different spreadsheet that uses vlookup to extract information from a same data spreadsheet(same across all the excel workbook files). So basically lets say I have 6 excel workbooks, and each of the same spreadsheet "A"...
  18. L

    Formula to Access Shipping Table

    Hi All, Complicated one (for me at least) I have this rather all encompassing Shipping table document, I want to create a formula that will allow a user to input into one cell a country name (its easy to make this lookup the 3iso code) and then input a deadweight to give a shipping cost...
  19. F

    Cross Referencing cell data and showing data mismatch

    Thank you for taking the time to read my post. I have the below code which works for comparing 2 spreadsheets and the cell data when they are aligned correctly. The problem that I have is that a row of data can be deleted from one worksheet and not the other and this causes the formula to...
  20. D

    Keywords match in excel

    Hi, I have a list of keywords in Sheet A (2000 rows) and I have a sheet B (column B), where I want to highlight Column B or get YES/NO (in nearby column D) if the cell of column B contains any keyword. For example - Column B cell contains "30secondMBA.com" and I have a keyword "MBA". If I...

Some videos you may like

This Week's Hot Topics

Top