vlook

Hi, I wonder if this is possible to achieve. I have a sheet with information since week 1 of the year. And i am trying on a separate sheet to do a vlookup to separate the info for each week. Example. First sheet (spaces indicate a different column) Name Week Number Delivery Success...

Sheet1 SL NO URL Value Country Pages 1 https://www.google.com/ 8 US 23 2 https://www.facebook.com/ 102 UK 8500 3 https://www.amazon.com/ 56 Germany 400 Sheet2 SL No Domain Value Expected Result Value 1 https://www.amazon.com/ =VLOOKUP(B2,Sheet1!A1:E4,3,0) 56 2...

Hi All, I'm trying to add quantities values of a table depending of the category reference and costumer (on this case "A"), but I cant figure it out why I have and error on my formula (#Value!). Category Costumer Qty 1 A 70,700 5 B - 3 A 21,000 3 C 12,136 5 B 6,560 1...

Hi, im hoping someone can help. i have a data set that is continuously changing from the source and i need to keep a running total month by month. i am wondering if a VBA code could help. my source is coming from "Tab1" A22 downwards and it can depend on how many rows down this always changes...

Iam trying to Vlook from one work book to another work. Cursor is locating correctly but not picking up the lookup value. Dim LValue as String lookFor = Internal_Sheet.range("A2").value Set IFRange = Snow_Sheet.Range("A1:I200") LValue = Application.worksheetfunctions.Vlookup(lookFor...

I have two workbook with D column having unique number. How can we remove the duplicate in 2nd file based on 1st file data? Vlookup cannot work, as when i do Vlook up it picks up the data of 1st record as well on the 2nd record which should be the 2nd vlook up data.

Hi There, I could really use some help. I am trying to figure out a way of looking up sale data though it must be for a certain week and certain SKU. The sheet i currently have has the weeks in the columns and SKU in the rows, whilst i have the sales data on a seperate sheet containing the...

Hi, When I do a vlook up, is it possible to get the the "content"+format (color font) of retrieved data? Thanks, Edu

Dear Community, I am currently trying to do a VLookup and I was hoping you guys could help me save some time. I want to lookup multiple text inputs and return the greatest value among those inputs. I am sure this is a simple task and I am afraid I have over complicated it. This is for a...

<tbody> A B C ID1 ID2 Name 001 A010 John Smith </tbody> Hi All, I need some help here. basically, some of my employees have 2 IDs, If I vlook A, return is N/A, then I should be able to vlook B to get the name "john Smith". how can i put that logic into one formula? Thanks,

Hi All. I'm attempting to sum up a list of times, from two tables IF their names match. Daily i go through a long list and + them manually. Tried to mix IF statements and VLOOK UPS and didn't get anywhere with it. Can anyone help me? <tbody> Sam 00:39:36 Kate 00:38:05 Dan 01:20:53 Pete...

Hi everyone, How can I subtract two vlook up values and return the valu in a cell: VLOOKUP($C194,History.BalanceSheet.Current.Year,MATCH($D$137,History.BS.Current.Year.Date.Vlookup,0) - VLOOKUP($C198,History.BalanceSheet.Current.Year,MATCH($D$137,History.BS.Current.Year.Date.Vlookup,0) many...

Hi, Got a question i'm trying to write a vlookup with multiple criteria. I've writen. =Vlookup(G1&D4,'daily breakdown'!a2:av154,30,false) But i keep getting an error message. what am i doing wrong?

I have 500 rows of 6 digit numbers where I need to assigned a unique value based on first three digit of the number: For example: 100000-199999 Assign value U023 200000-299999 Assign Value U220 300000-366999 Assign Value U222...

Hi, I'm new to this forum. I am trying to create Part and Price data base, where entering in a particular part number and quantity pulls up the serial number and price depending on quantity ordered. I was able to do a VLOOK UP [formula used is "=VLOOKUP(D2,$A$7:$B$61,2,FALSE)"] to find the...

I am trying to generate a formula that will automatically populate the following data. I have tired various VLOOKUP, INDEX/MATCH Formula with no luck. Here's the Data <colgroup><col><col></colgroup><tbody> FRI NG CHEM RACK 06 C:13 2300120694 FRI NG CHEM RACK 08 D:10 2300120728 FRI NG CHEM...

Hello, I am having some troubbles. I understand the v look up function. I am having trouble making a v lookup to a complacently separate file then the file I am working on. the trouble is that the file I want to v look up is updated 2 two times a day from our online portal. How do I make it so...

Hello, I have a question about vlookup. I have a work book open with over 10000 lines. In (A) have a resource name like "Final", "3-Axis" In column (O) I have number of "days late", In column (P) I have number of "days aged". If i wanted to find out how many jobs I have under each...

Hello All, I am looking forward for some help regarding Vlook with multiple criteria. Basically i am looking forward to get data from one sheet after it meet both criteria. If Instance, If Employee Id match than please look for date and return Column C value. <tbody> Employee ID Name...

I have a list where I have banks name. Every time I select a bank from the drop down list, I would like a prepoulate cell values automatically like for example below: Any help is really appreciat <colgroup><col style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;" width="41">...