look-up

  1. R

    Advanced Lookup Help

    Hi all, I have a pretty complex look-up issue and wondered if anyone can help? The link to the G-sheet and criteria are below (also within the G-sheet): Link: https://docs.google.com/spreadsheets/d/12xETyc1bCqATpTdb--nZWRjVD9XCGHDb75f4YKMzhxA/edit?usp=sharing Criteria 1) Look down column B in...
  2. 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...
  3. 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...
  4. 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?
  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. 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...
  7. 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...
  8. 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 ...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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__...
  14. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top