look-up

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

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

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

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?

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

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

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

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

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

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

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

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

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__...

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