vlookup #value!

Having below issue while applying vlookup Column A1 to 100 contains customer codes, all numerical Column b1 to 100 contains customer balances A and B values are loaded directly from accounting software through Excel add-in. Column A values are all digits but loaded in text format. In cell...

Hi all, I have the following formula: It checks if the cell in C9 is blank (which it is not, the text is just hidden) and then returns the current date of today. However, I am also referring to cell C7 in another cell, specifically like this: My issue is, obviously, that the cell...

I am do a compare of two different spreadsheets, it is working fine, except in cases when the employee has more than one line of data. I want it to add each line together to give me a total. is that possible? For example, I am comparing labor amounts to payroll amounts, so if they charged all...

Hi my fellow excelorians I am trying to enter a formula of nested vlookup within a concatenate statements but for some reason it ain't working and I am guessing its probably a syntax issue that I just have not been able to see (trees for the forest scenario) The formula entered is as follows...

Hi All I am finding it hard to get results in the following scenario: I have three worksheets Sheet 1, Sheet 2 and Sheet 3 In Sheet 1 I have a drop-down with values i.e. Team 1, Team 2, Team, Team 3 and Team 4. In Sheet 2 I have 4 Columns with the headings Team 1, Team 2, Team, Team 3, Team...

Good day new to this community. I've been trying to use the following formula to have data on the LEFT of the same CELL to clean it and use it to VLOOK up another sheet and brining in a code. Formula: = VLOOKUP(LEFT(H4,(FIND("V.",TRIM(SUBSTITUTE(H4,CHAR(160),CHAR(32))))-2)),'Vlookup...

Hello, I’m trying to display the latest value entered on adifferent tab (pretty much a Vlookup example). In the column on “Tab_2” an employee enters the new amountof mileage driven in the rented car once it’s returned (see example below. Date and Mileage are two different columns)...

=IF(Checklist!B27="","",VLOOKUP(A176,Features,2)) I have the above formula on my worksheet A176 has the value Feature 10. The Named Range is the following; <colgroup><col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="64" style="width: 48pt;"...

Hi all, I'm having problems with some VBA script, and would appreciate any feedback on what I may be doing wrong - I've been using VBA for a few years but this is really beyond anything I've tried before. The relevant sections of code are below, and the scenario is this: I have a workbook...

Hello, I am trying to do a lookup based on a variable file name which I'd like to fetch from cell I2. I am very new to complex excel formula so am hoping someone can tell me exactly what I need to do to make this work! I've tried looking around other peoples posts on this and adapt it but get...

Hello -- This is my first post and I'm having trouble with this formula. Whats going on is there are 10 values in column "A" and 10 values in column "B". I'm using VLOOKUP and LARGE to find the largest 5 values in column "A" then add the corresponding 5 values from column "B". However, if column...

Hi What is problem with this code It show error: Run time error: "-2147352571 (80020005)": Could not set the value property. Type mismatch Private Sub ComboBox1_AfterUpdate() Dim ws As Worksheet Set ws = Worksheets("Sheet2") Me.ComboBox2.Value =...

Hi, I have vlookup ActiveCell.Formula = "=IFERROR(VLOOKUP(R2,'" & sfullpath & "'!" & Rng & ",3,0),""Other"")" and it's working. But I don't want to start from R2. Possition is choosen before and it's called rows_x_begin: for example: rows_x_begin = 26 so it should be R26 how to add...

Hello, I am new to MS Excel and I have small question. On Sheet 1, I have the following data (in column order): <tbody> Response No Table No Survey Date Constitueny Names (AC) Mandal Names Village Names (I have data) (I have data) (I have data) Need to find Need to find Need to find...

Hi, Help Please. I have two separate workbooks, Workbook A & Workbook B. In both workbooks, I have two columns (G & H) where a series of codes are entered in, but not in order. For example: Workbook A: G3 = D12332 & H3 = 1 Workbook B: G17 = D12332 & G17 = 1 What is the formula for: If the...

#VALUE! started appearing when I slightly changed my formula. From: =IF((TODAY()-F3)-(IF(G3=$A$2,$A$6,IF(G3=$A$3,$A$7,IF(G3=$A$4,$A$8,IF(G3=$A$5,$A$8,"")))))>1,"Must Call",(TODAY()-F3)-(IF(G3=$A$2,$A$6,IF(G3=$A$3,$A$7,IF(G3=$A$4,$A$8,IF(G3=$A$5,$A$8,"")))))) To...

Hello Everyone, So I'm trying to compare 2 tables (an Old one and a New one) and I want to validate that everything on the Old one is contained in the New one. Both tables are just 1 column and about 17500 rows. Each value on each cell of both tables is about 400 characters. The formula below...

I have a spreadsheet that I had send to me one of our sites that we use for User Access. It was exported straight from the program. I am having trouble in the formatting of the spreadsheet in order to make it searchable and to use VLOOKUP. In the Full Name column, the first and last name look...

Hi There, I have a problem I need to not only return the highest value per sales rep but the name of the deal. <tbody> Opportunity Name Opportunity Owner Unique Sales Price Arriva_Mittelstand Andrea Junge 130.000 Siemens-CIT-ARIS Design Server Denis Wachsmuth 17.600 Telefónica Alfabet...