# look-up

1. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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...