# vlookup and if

1. ### Vlookup or IF Statement Help

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...
2. ### Help with if formula within if formula

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...
3. ### Userform & VLOOKUP to populate fields

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...
4. ### Average multiple cells with vlookup?

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...
5. ### Impossible Vlookup + IF function

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...
6. ### Vlookup- multiple values

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...
7. ### Vlookup

=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))))...
8. ### VLOOKUP and wages in timesheets/rosters

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...
9. ### Macro to Copy Entire Row, Insert text Left of Pasted Cell?

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...
10. ### Adding text to a column based on value in another column

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...
11. ### Secondary sort of League Tables

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...
12. ### vlookup + if isna formula should return blank if 0 but dosn't??

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...
13. ### Vlookup and when to stop

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...
14. ### V Lookup Help

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
15. ### combine vlookups help

<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...
16. ### Filter Out Duplicate Info Onto a different Sheet

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...
17. ### Problem with msg box

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
18. ### IF Formula with Vlookup Built in

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
19. ### If, VLookUp, and date. Future date Lookup problem.

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=...
20. ### vlookup/ if ... maybe??

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

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...