v lookup

Hi, all i need some help with a look up function. I understand the basic principles of how they work , but I cant figure out how to make them work with a date range. My look up data looks like below. I need a function that will take a Date and look within the Start Date and End date to...

I have a Vlookup that takes a vehicle registration and looks up the drivers name. The information is pulled in in two columns - First name and Last Name. I then have a third column where i have a concatenate formula to bring the name into one cell. If the registration is not found I get an #N/A...

I could use some help! When I try to do a v-look up on a spreadsheet I've used for 6 months the table array doesn't work. On the spreadsheet I'm pulling from when I go to highlight the columns it turns red and puts $ signs. Then it crashes my spreadsheets. I can't post a screenshot here but...

Dear Excel Wizards- I have a list of about 105,000 email addresses in Sheet1, and in Sheet2 I sent a opt-in/opt out email to 15,000 contacts. Now I am trying to separate out the action each email took IF they were the lucky 15,000 list- bounce, clicks, unsubscribe, opened, etc. using a...

Hi Helpers, I'm not sure if this is indeed possible, but thought i'd give it a go as you all have been so helpful in the past. I have two tables in two separate worksheets ("WKST1" and "INV2") as shown below. INV2 references WKST1. In Column D of INV2 I am using a SUMIF equation to total all...

I work with some software that generates various reports as excel docs. The naming convention is always the same for these documents. There are a total of 4 documents I draw from to make a final report. Most of the numbers on this final report are simple cut and paste from one workbook into...

Hi there, I don't know if a similar question has already been asked on here but I couldn't find it, so I'm sorry if I'm repeating! My question is this. Twice a week, I produce an invoicing report for our project teams. This details the project number, the billing status and the monetary...

Hi there, I am looking for a way of extracting specific data from a large Excel data set I have. For example, if the below is my large data set... <colgroup><col><col><col span="4"></colgroup><tbody> Team Account Manager Jan Feb Mar Total A Daniel 2 5 5 12 B Jane 5 8 3 16 C Gill 3 6...

Hello, I desperately need help here. i have been asked to complete a task that involves copying files with 5 sheets ( around 10 files within folder) to another folder and vlookup from different set of files some data (all file names within folder and sheet names are identical) just exactly...

Hello, I am looking for a Macro which can always match values with column A and reflect the similar values between column A and Column B on Column E. So, the values in column A are always constant, these values are the standard/defualt values that we are using always to match. Column B are the...

How would I do a V Lookup function if I had column A listing 48 entity numbers and column B listing 48 bank account numbers. I want to have a cell pull the bank account number associated with whatever entity number I type in the cell next to it

Hello: I have created two drop down lists. The first drop down provides seven options and then the second drop down gives options based on the first selection. After the second selection is made I have created a v-lookup below to display all information relating to this selection (around 10...

Hi, Could someone please help with the following formula? =IF(COUNTBLANK(A2)=0,VLOOKUP(A2,Geology!$A$2:$D$7560,4,TRUE),"") I would like to eliminate any '0' values in my results, however many '0' values are being returned because there are many blank ("") records in row D of the Geology! tab...

I have a Range of Cells that I would like to transfer to PowerPoint using VBA Macro. The problem is that some of the cells are emty at times and I want to leave them out of the final range that is moved to PPT. I'm thinking that I have to select the largest possible range and then do some...

I have a sheet template that I have created to incorporate into various workbooks. This template sheet has a number of Vlookup formulas. The problem is that, when I insert my new template sheet into the current file, the formulas reference the old sheet in the old file. I would like to have one...

In row A I have about 5000 SKUs that are generally a few numbers and then a few letters. For some reason, even though I go to "format as number", they all still have errors saying "Number Stored as Text". Because of this formatting error, the V-lookup doesn't return a value. But as soon as I...

I have a column full of phone numbers. I would like to be able to denote what time zone each number is in, in a separate column for each corresponding row. How can I do this? I would imagine the formula would look at the first 3 digits for each number and then be able to identify what time...