excel vlookup

Hi, I have a bill of material that is uses VLookups to reference a table of supplier cost prices. In the attached image you can see that cell U5 has the suppliers part number 'LABOUR' and cell V5 is doing the lookup and adding in the description and cell X5 the same lookup and adding the...

Hi, I was wondering if someone could please help me with a Vlookup. I am creating a product bill of material and performing a Vlookup to each of the supplier parts which I have in another supplier spreadsheet. This is working fine, however I have an issue when no match is recognised in that...

Hi, please can someone help advise me. I only know basic formulas in Excel (Not macros). I have a spreadsheet where I want to perform a lookup value to a list of products. If the product is found in the list I would like to display the product price, if no product is found then I would like it...

All, I want to thank you in advance for helping me. I just need help creating a custom IF/VLOOKUP string based off of a list table. I will attach the file for an example. It should be pretty straightforward. Once I get past 3 or so IFs combined it starts getting choppy for me. I really do...

I keep getting the #REF when i copy this vlookup down and have no reason why. Please help, the sheet and cells it is referencing is =IFERROR(VLOOKUP(A16,'Locked Forecasts-DNT'!A2:AI1048576,35,0),"-"), usually works when i manually type it but can't do it any other way. thanks...

I AM TRYING TO USE VLOOKuP FEATURE TO LOOKUP TWO DIFFERENT CELLS AND PULL OUT VALUE FROM TWO DIFFERENT TABLE. SORRY IF MY EXPLANATION IS NOT CLEAR BUT HERE IS WHAT I AM TRYING TO Do LOOK UP TABLES: <tbody> CITY TAX RATE COUNTY TAX RATE A 9% LA 9.25% B 9.5% SA 8.5% C 9% SB 7.25% D 10%...

Hi Folks, Here is a macro for word to word translation. Sub macc() Dim d() As String Dim myValue As Variant myValue = InputBox("Input Cell ID") d = Split(Worksheets("Titles").Range(myValue).Value, " ") For Each i In d a = Application.WorksheetFunction.VLookup(i...

<tbody> Item1 Item2 Item3 N1 N2 B C D XX MM C A A YY NN A E D WW OO A B C ZZ PP </tbody> <tbody> Item_Name F_Name L_Name A-B-C ZZ PP C-A-A YY NN B-C-C XX MM A-E-D WW OO </tbody> I have a data which is the Table-1 in one sheet and in...

I am trying to get the correct formula to count the number of days it has been for each employee since the last occurrence of an absence/tardy. For each employee, starting with the beginning of the year, we mark and employee as Absent as an "A" or Tardy as "T". See below the examples...