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