Vlookup Related Problems & Solutions

62 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 30 of 62
[Solved] Formula to check entry for duplicates in same column
Summary: I have this Excel sheet with just one column (A) in which I input just numbers in each row. I would like to create a formula so that each number, befo...

[Solved] Having trouble creating a If/then,Vlookup statement in Excel
Summary: Is it possible to create an if/then and Vlookup statement in Excel that copies a whole row of information and populates a different workbook once a ke...

[Solved] Using IF AND with Vlookup
Summary: Hi there, i am trying to find a way to come up with a formula to organise a sheet i am working on. Basically I need to do a few factors 1. If O=TRUE ...

[Solved] How to write a formula with IF and vlookup
Summary: How to write a formula with IFERROR and vlookup, when the data to be looked up are in a separate sheet within the same file? Thanks for teaching me. ...

[Solved] Move a cell and contents next to it's duplicate
Summary: I have a Column (column A) with invoice numbers (123456) that have the corresponding payment type (text) in the column next to it(Column B). I need to...

[Solved] How do i use the if function with a vlookup?
Summary: If A22 equals a number in the range from B5:B21 then I want the corresponding row number in column A in the range from A5:A21 to be displayed in B22 ...

[Solved] how to use IF statements when using Vlookup
Summary: I'm trying to figure out how to use the VLOOKUP and IF statement so when their is value to say "Yes" or "No" when there is no value. ...

[Solved] Lookup problem with same name appearing
Summary: QZ4:QZ51 is a list of values SO4:SO51 is a list of names QX61 = 3 (contains the formula =IF(LARGE($QZ$4:$QZ$51,1)>0,LARGE($QZ$4:$QZ$51,1),0) QX...

[Solved] Excel Vlookup over multiple sheets
Summary: I am looking to do something similar to a Vlookup, but I have 9 sheets through which I want excel to look. Basically, I have a list of names with data...

[Solved] Need an excel function to handle verticle lookup for dash #s
Summary: Basically I've got to do a vlookup to calculate two different price increases for a list of model numbers. But since some of the model numbers have da...

[Solved] can i clear a blank charactor from a downloaded name?
Summary: I have a situation where I down load data and delineate results leaving a name with blanks behind the number making a Vlookup difficult. ASIAN HONDA M...

[Solved] VLOOKUP not bring back the correct figures.
Summary: I have a VLOOKUP formula looking at a simple pivot table =IF(ISNA(VLOOKUP(D10,'Pivot Table'!$A$2:$B$2000,2,FALSE)),"0",(VLOOKUP(D10,'Pivot Table'!$A$2...

[Solved] VLOOKUP problem/poser providing a list
Summary: Hi there, Just a random little poser regarding VLOOKUP In Cell D2, I have a value, lets say that value is 15 I have a list of values in Column E, from...

vlookup URGENT HELP NEEDED NOW PLZ
Summary: I have 8 sheets with data and 1 master sheet. All the sheets have the same format. I have a drop down cell with the names in the master sheet and want...

[Solved] i want to write a formula on page 2 to pull info from page 1
Summary: i want to search coulmn a for an item and then transfer content from corresponding cell in column b to page 2 what is the formula to do this ...

[Solved] Vlookup across multiple worksheets
Summary: I have 2 different reports that have part #'s along with brand names, just in different columns. The first report has the part # in column A and brand...

Macro the uses data list to compute property costs
Summary: Macro help - I want to create a macro to automate certain processes: 1. Customer chooses a property name form a drop down list and clicks 'run macro'...

[Solved] Vlookup with sum across multiple sheets
Summary: I am trying to create a summary sheet based on several sheets in my workbook. I say several, because the number will be changing throughout time. Ther...

VB Comparing data in one sheet to another and copying cells
Summary: I am new to VB and have searched for existing answers to this problem but no macros or VLOOKUP commands seem to work. I want to compare date/time in ...

I want to copy a hyperlink in sheet 1 to sheet 3.
Summary: Sheet 3 uses a VLOOKUP and returns the hyperlink text but only as text and not a hyperlink. Please help!! ...

VLookup to 2nd last created worksheet while in latest
Summary: I got a spreadsheet where I add a new tab every month so what I want to do is automate so that when a new worksheet is created, in Column L of it, I p...

[Solved] Using Vlookup to return a blank insted of 00/01/1900
Summary: I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are dates this ...

[Solved] 50 states and counties
Summary: I made a lookup table of the 50 states and beside each state, the salesman's last name. I put a simple VLOOKUP formula in a speadsheet of projects, s...

VLOOKUP wont work not working correctly
Summary: Please HELP Ive got a Vlookup buts its not seeing all the data correctly and I cant work out why. Although I can there should be a match is comes up ...

IF statements using VLOOKUP
Summary: I am trying to create a formula for a timesheet. The EE would enter todays date, then I want a cell with formula, to automaticlly determine the Perio...

[Solved] Excel if and vlookup
Summary: Hi i'm in need of a code for excel that can look in a cell and compair the word in the cell with a list of words if the value is found in the list it ...

Searching multiple sheets and tallying values
Summary: I have a workbook with 24 sheets. Each sheet has a parts list F11:K100. On sheet 25, I have a list of all the part numbers used on all of the parts li...

Compare a A2 (Sheet1) cell with a column A (sheet2) if A2(Sh
Summary: I need to check A1(sheet 1) with the column A (sheet2 )if the value matches in any of the cell of coulmn A(sheet2) i want the data from correspondence...

Using IF and Vlook up
Summary: I have to find a mobile number is there in any of the 2 sheeets of data, I am trying to use a comibination of If and Vlook up, it works with the first...

[Solved] Vlookup formula - copy and paste not working
Summary: I am using a vlookup to retrieve bonus for employees based on years of service. The problem is when I copy and paste the original formula, it does not...

123


Ask Question