look-up

  1. B

    Look-up Formula Logic Update

    Hello, I have the following look-up formula: =IFERROR((VLOOKUP(AG2,Sheet2!$L$2:$M$617,2,0)),"N/A") I would like to add a condition to this formula that says: IF Column BD = Hello, then return a value of "MK" regardless of the look-up value. Essentially, this logic should override the value...
  2. B

    lookup logic to interrogate specific exceptions

    Hello, See the below data example. Purpose: Output a 'Y' or 'N' based on a look-up. If the data is found in the columns in the look-up, a 'Y' is output, else 'N'. This is probably a IF/THEN type logic, but your assistance is greatly appreciated! Logic/Rules: 1) If the look-up matches...
  3. Sigh

    Look-up table data

    I have inherited a spreadsheet which contains a look-up table and now need to update the text and figures in the table but can't see where the original data is stored, is there a simple way of finding it?
  4. H

    Picture Look-Up

    Hi, I am novice in world of excel. I am preparing a table in which I have to look-up images based on a cell value. Is there any way to do it, with the google help I am able to lookup pictures if I lock a cell in defined name formula and then change it's value but when I unlock the cell to work...
  5. H

    Picture Look-Up

    Hi, I am novice in world of excel. I am preparing a table in which I have to look-up images based on a cell value. Is there any way to do it, with the google help I am able to lookup pictures if I lock a cell in defined name formula and then change it's value but when I unlock the cell to work...
  6. A

    Trying to create an at risk register to track my students

    Hello all, I am trying to create an At risk register so i can track my student that have several classes. Each tutor has there register that they enter an (A)-Absent, (P)-present or (L(10))-Late and number Minutes, i need something that will look over the other two subject spreadsheets for a set...
  7. J

    Need Help with a Look up formula.

    Hi Guys, I need some help regarding some work related calculations. I need a formula or a methodology. :confused: Assume there are 2 tables Table 1 <tbody> Date ID No From To Distance KM 1st Jan 12546 Point A Point B 5 2nd Jan 15976 Point B Point C ? 3rd Jan 14753 Point A Point C ...
  8. S

    Formula Solution - Look-up last value from this row or above

    I'm trying to find a non-vba solution to this problem and I've searched and searched online but I think I might not know the correct terms to search effectively. I want to populate every row of column A with the correct name in column B. so A1&A2 are Frank, A3&A4 would be Leslie and A5 would...
  9. F

    Check if value exists in an array of cells, and based off of the result perform a calculation

    Hello, I am having difficulty with a formula. My level of excel is pretty intermediate in the fact that I know how to perform basic functions/formulas, but this is over my head a little. So help is greatly appreciated! I have two worksheets. One is a reference table, and the other is where I...
  10. S

    Populate cells if value "contains" a values in a look-up table

    Hi, This may be too complicated for this forum, but I thought I'd ask. I was wondering if someone can help me to create a button which will be available on every row and populate an income or expense category based on a look-up table. Sample of My Spreadsheet: Row B <tbody> A B C D E...
  11. G

    How to highlight deletions from sheet 2 on sheet 1?

    I have an Excel spreadsheet. On Sheet1 I have a vast amount of data (over 7000 rows and up to column AA): eg A Code, B Description, C Page, etc etc AA Proposed Deletions (this column is currently blank and I want to highlight from those found in Sheet2), On Sheet2 I have a list of proposed...
  12. G

    Urgent help needed!

    Here is an example of what I want to do. This is what the data would look like: DATE RATE1 DATE RATE2 DATE RATE3 1/06__ 3___ 1/06__ 4___ 1/06__...
  13. I

    Formula based column B return A in list format

    Hello I am very inexperienced with Excel. I am hoping that someone can give me some help. How do a create a list based on frequency without blanks. "Daily duties", "Weekly Duties"? What I have is a worksheet (Duties-Alpha) This has column A Duty, Column B Frequency, Column C Responsible Pary...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top