vlookup

I perform a vlookup command on a pivot table. Results are not same as I expect. Is there any limitations for performing vlookup command on a pivot table? And very oddly when I perform isnumber command and numbers in pivot table, the result is: FALSE. I have to add, Isnumber returns FALSE for...

Hi All, I'm looking for help on a formula reference using VLOOKUP. I have a table which maps some project names to Sheet names, as the project names are very lengthy but the Sheet names are small enough for the tabs in Excel. Using that table and VLOOKUP, I'm looking to use the output of the...

I'm developing a sprdeadsheet using MROUND and VLOOKUP. The VLOOKUP acts strange when the MROUND cell displays a result of 2:30, 3:30...+ but not otherwise. it returns the result for 2:15, 3:15...+. If i override the MROUND and enter 2:30 manuallly it works. Paste special does not work. I have...

I am experiencing a problem with vlookup that is.. frustrating me. I admit that my primary skillset is not in excel, but I thought I knew what I was doing. But I'm struggling to understand what might be causing this and I hope someone can point out something obvious that I'm just not seeing...

I'm having issues with this formula set up. Week Data Validation List 1-18 Team Data Validation List of Teams VS Long IF/VLookUp Formula So in A2, I have a drop down to select the week number, and in B2, I have a drop down to select a team. In B4, I have this formula. The idea is to...

G'day. Am in need of some help and I'm not totally sure where to start in getting this to work. Maybe an XLOOKUP, but I really can't figure out how to lookup one value, and then another, and then produce the result. I have attached part of the sheet via XL2BB below. What I need is the table on...

I am trying to add a vlookup code to a cell and have to reference the worksheet to the left/second to last sheet in the workbook. The name will change since it's a date, not always the date prior because of the weekend. Some things I tried are below, none worked ... Dim sh As Worksheet Set...

Hello, so I'm using Microsoft Excel on Office 365 and I'm using the VLOOKUP function and having some issues. Here is the current state of my formula I'm trying to troubleshoot: =VLOOKUP(C3&"*",A:B,2,FALSE) Column A is filled with identification keys composed of letters and numbers while column...

Help? We are moving records from one provider to another and their downloadable information is difficult to manipulate into a format suitable for import, and rightfully so. (Can you say Job Security?) But we ARE moving. Please see attached image. The data is paragraph-like...

Trying to figure this out and it’s probably something quite simple. Layout: I have a running log of information and events that are entered in with dates and times. From this I have a table using COUNTIFS formulas set to count the number of times certain events take place during each 8 hour...

Hi all! I am having an issue with XLOOKUP and VLOOKUP and can't figure out if it is a formatting error with the text, specifically the 'XH' at the start of the text To my eyes, I have checked the data set both sides and the format is the same for both so the lookup's should work The formula...

Wondering if anyone could help me out on this one. I've created the Function below (which I'm using as an Excel Add-in), which looks up a value of the selected cell (SKU) and returns the value it finds in a specific workbook that is stored on a specific location. Right now this code it is...

i have been trying to solve the following issue: i have a very long column of values (in this case there are only two values = FY23, FY24, with FY23 always coming before FY24) and another column values (all zeroes except one value >0 in an FY23 row and one value >0 in an FY24 row) i want to...

Hello, i have these data examples : Company Date Invoiced Services Invoice Number Sales Figures HP 23-Jan-21 Some data 001 8,000.00 Dell 25-Jan-21 Some data 002 6,000.00 Microsoft 04-Sep-21 Some data 003 6,000.00 I want to make reporting for sales figures by month. That is...

Good Morning, I am looking for help on editing the formula seen in the first attached image. The formula itself is working, however, I am trying to edit it so that the formula auto-populates down the entire table. As of right now the only way to get the formula into the cells below is by...

Dear All, I am trying to enter employees bank loan interest recover detailes in excel sheet ("3-2 Reimbursment" Sheet). For this purpose i use two sheets, one "3-2 Reimbursment" , other "Loan Details". in Account Details sheet, there are many emloyees details and some amployees may have more...

So I'm trying to return a cell value from a table, relating to a text based cell as the searching tool. It's actually part of a larger formula, but the rest is straight forward. I am trying to return a result where if the day of the week changes in A2, it changes what cell I use in a formula in...

Hi all, I've got a table with 4 columns(B~D), Item, Store, and Time. In Column E, I want to write a function that looks up the value from "Item" and "Store", then returns the value of "Time" of the last row where both "Item" and "Store" values are matched. So for example, E3~E9 will have the...

Likely a tough one here. Simplifying a complex worksheet here. But basically: A1 = Value A2 = Value A3 = Value A4 = Value A5 = Picture based on A1:A4 values. Limitations: Pictures have to be referenced from within the excel Workbook. Not external to a referenced folder or website. I can...

I have variable lists that will have 200–1000 values in them. ex: 1 Reliable 2 Practical 3 Responsible 4 Organized 5 Detail-oriented 6 Logical 7 Hardworking 8 Dedicated 9 Honest 10 Loyal etc... The user will be able to put a number in a cell and a different cell will...