vlookup

Hi, This formula works, but I was just wondering if there was a more condensed/better way to write it.. =VLOOKUP("716",BJTABLE,10,FALSE)+VLOOKUP("717",BJTABLE,10,FALSE)+VLOOKUP("718",BJTABLE,10,FALSE)+VLOOKUP("719",BJTABLE,10,FALSE) Thanks :)

Hello Excel Gods, I have (what I hope) is a fairly simple issue, but have cooked my brain trying to find a solution. There's a good chance my brain was already cooked though, apologies in advance. Here's a silly, bare-bones example to illustrate: On my first sheet I have a database of friends...

I have an Excel sheet where I need to track completion progress. On Tab 1, I have a data that will constantly change (will be copy and pasting data from a downloaded report) but the number of columns and rows will stay the same. Each name in Column A is given a score for each module and there...

Dear community, I am trying to resolve following challenge. I have fill data from one table into another one. I am using Vlookup function but it only brings the first unique value. I need to figure out how to bring first unique value as result A1 and secong unique value as result of A2 A...

Hi, I am hoping someone can rewrite my Vlookup formula. The formula is currently =IFERROR(VLOOKUP(B176,'Material Purchasing'!$B$2:$E$999999,4,FALSE),"") And the purpose of the formula is to search for a PO Number (B176) within the range of Material Purchasing'!B2:B999999 and return a value...

Hi All, ABCDEFGHIJKLMNOP DateSkuCodeQtyPoOrder#NameShip DateTrackingCourierInv#CostShippingVatTotal Inc. VatStatus =IF(OR($B4="",$D4=""),"",IF(B4="","",(VLOOKUP(@$B$4:$B$500,Formulas!$A$1:$F$26,4,FALSE)))*D4) I am using the above formula in column L and M to pull in a cost price for an...

Hello, I have sheet 1 and sheet 2 which contain data. I have sheet 3 on which I want to report Data for some (not all) rows in sheet 1 and sheet 2. So that when I insert the refs in column A, the data appear in columns 2 and 3. Thanks ! sheet1 IN0001AppleRed IN0002PearGreen sheet2...

Hi Appreciate your help in advance. I need to get my head around VLOOKUP and hopefully its the answer to my issue. I have a large set of data with a column of unique ID references. - a months amount. For a reconciliation i have a sample of data, from that same column of unique ID references...

Any all all help is appreciated! I’m operating out of a company SharePoint, as multiple people need to be able to access these sheets. I want to have a Master sheet, that tracks information from ~300 individual site portfolios. I want the Master sheet to be able to automatically pull about 30+...

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