vlookup and if

Hi all, I need help with Vlookup Currently I have a spreadsheet setup so that when I enter information in Column B on Column C looks up a vname (Which is on a different sheet) and puts the correct value in the box. Everything works fine but I want to paste a large number of data into Column...

HI, Can someone please help me??? In cell L3 I need to execute this formula... =IF((L8-I14)>0,"YES","N/A") but I only want this formula to run if the cell I10 contains the text YES. If the cell I10 contains NO I want the cell I10 to display N/A. PLEASE HELP ME!!!!! I have spent hours...

I am new to Userforms, but have successfully created one where all entries work - except one. I am creating a Userform for a student directory. If I create a user as NEW, it works fine. However, I have information from previous years that just needs to be updated, not NEW. This information...

Hello, I am new to Excel but I know how to compile basic functions. Here is what I am trying to do. I have 2 sheets currently. Sheet 1: Name Week Score John 1 3 John 1 2 Mary 2 1 Mary 2 3 John 2 5 John 2 1 Sheet 2 (Week 1 Average): Name...

I have the following issue where i have to analyze actual bookings, and ensure they follow the allowed combination criteria. How can i make an excel vlookup/macro which compares the actual bookings to the allowed combinations, and if they dont meet the allowed criteria, returns an N/A? Actual...

The cells refer to numbers. I am looking to match numbers on one worksheet to another. Some cells contain the same numbers and it pulls the first one... This is a formula I am working with. The problem is that it picks out the first value that T15 matches to, and disregards the rest of the...

=IF(VLOOKUP(T15,'Ex Clear'!$S$2:$S$2001,1,FALSE)=Govi!T15,IF(VLOOKUP(Govi!S15,'Ex Clear'!$U$2:$U$2001,1,FALSE)=Govi!S15,IF(VLOOKUP(Govi!B15,'Ex Clear'!$W$2:$W$2001,1,FALSE)=Govi!B15,IF(VLOOKUP(Govi!A15,'Ex Clear'!$X$2:$X$2001,1,FALSE)=Govi!A15,VLOOKUP(T15,'Ex Clear'!$S$2:$V$2001,4,FALSE),0))))...

Dear all, Having had alot of success here I am turning to you all to help me. I am trying to create a time sheet that will return two different results depending on the salary structure. I have successfully create the formula for a employee on a casual rate to look up the level they are on...

Two questions I first want to be able to copy that entire row that lookup value is associated in and copy where I currently have it going below. Second how do I input a cell 3 (col A) to the left of the copied cells which are in col D. The text that I want to be inputed is"ExtraActuals." Thanks...

Hi, I have two tables in hand: Table 1: has data showing Customer no, Renewal Month, last_active_date, report_pull_dt and other columns. Table 2: has Renewal Month and Cancel Dt Limit What I have to do is add a column in table 1 (Status) based on their last_active_date . For example...

Am trying to put some league tables together for a local amateur football group. Would appreciate help where a secondary sort is required to separate teams tied on points. Goal difference is the tie breaker. Rank and Vlookup is what I've been using for the original sort but how do I then...

Hi, I have a fairy large workbook with about 20 sheets containing data + formulas and a "master" sheet to suck out total qty's from all the other sheets. I'm having problems with a =IF(ISNA(VLOOKUP formula that is on this master page (probably already in over 1000 cells) I was previously using...

I have created a list of part numbers, and am using a drop down screen to select part numbers (nearly 500). In the second and third column I am using vlookup so that I can get prices, which I want to total at the end. However, if I copy and paste the vlookup formula to a maximum of say 20...

Can Anybody Help Me with the Following VLookup Formula: =IF(E8="Bank hol",VLOOKUP(D8,Sheet4!$H$1:$I$12,2,FALSE)*1.5,VLOOKUP(D8,Sheet4!$H$1:$I$12,2,FALSE)) I need To remove the Annoying #N/A When nothing is entered in some of the cells, and allow it to carry on working out. Thanks

<TABLE style="WIDTH: 671pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1116><COLGROUP><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=98><COL style="WIDTH: 244pt" width=406><COL style="WIDTH: 103pt; mso-width-source: userset...

I'm using MS Excel 2000. Is there any way I can use autofilter and data validation list to sort and filter information (from a different sheet from other than orginal) and dynamically update and display it on another? Scenario: I have three sheets, one called Dashboard, Summary of All, and...

I have this formula That works MsgBox (Range("B6")) If i try and add the title like this. MsgBox (Range("B6"),vbokonly, "Question") I get a compile error can you help? Thanks

Objective: I'd like to return specific value based on a lookup condition. Specifically return x IF the person's ID # is in a range of values. My thought is that we can accomplish by using a vlookup within an IF. Can anybody help with the syntax? Thanks! BR

Goal: if today is greater than last day of month, if true then last result of month, if false: lookup yesterday in range $E$62:$AK$645, column 2. This is the formula: =IF(TODAY()>$E$643,F$643,VLOOKUP($BK$1,$E$62:$AK$645,2)) Col E= all dates of the year. $E$643 is the 31st December. Col F=...

Not sure if I'm describing this properly but .... Is there a formula that can look into page 2 of a spreadsheet and then display in a list on page 1 everything in 1st column that has the word "apple" beside it?? Please help if you can .. or point me in the proper direction ... I tried a...