return value

Hi, I am trying to return the value from "WorkbookZ" cell A1. The workbook is closed and I am trying to utilize the indirect function But it wont work. Any help? thanks

Hi, I am stuck on this, but if seems it should be simple? :confused: I have data that has months in it that are spelled wrong and in different formats etc. I need to be able to search the range of data I have created in a separate table in order to return the correct abbreviation into my...

Hi, I was looking for some help in coding a search button. I need a single text box in which people can type a name and press go. I then need the data displayed in a user-form. already have the user form as it is the same format as the one I have created for data entry and the data returned...

Hello All, I am trying to have a formula that will check whatever is in a cell, if it is one multiple criteria, then I want it to return something else each time it appears. So if I have 5 cells: Dog Barks Cat Purrs Mouse Squeaks Cat Purrs Dog Barks The left column contains one of several...

I have 12 files of 12 months marks. I have monthly test result on this 12 file. One another file (MANUAL.XLS) contain the details of the students. Now I want to make one another file where I will select the student name and Marks of the student will be taken from all 12 months marks file...

So I have two columns of code numbers. There are some code numbers that are the same in both columns. Column A 1082 112 113B 2239 8449 Column B 1082 113B 488 9490A 112 Is there a way to show on Column C which code numbers are duplicates from the two lists above? The result would look like...

I am using VBA in excel to insert values into an Access DB (if I should post in excel questions please let me know). In order to link my tables together I use the id from one table as the reference in others. Pretty standard I guess. Now the thing is, that the id is inserted using auto...

Hi, I have something of the following : Shee 1 (Name Range : Code) Column A -------- Column B School ----------- 1 College ----------- 2 University--------- 3 Sheet 2 Cell A1 = (Search for "College" in Name Range Code and get the Value of "2" as code. ) So value of 2 should be present in...

Hello, It would be great if anyone could help me =] So sheet 1 has a list of chemical codes and next to each chemical code shows its corresponding quanityt. I want cell A2 in sheet 2 to look at A1 of sheet 2 (a specific year: 2007), and if this is the correct year then I...

Hi, I have 4 columns of vlookups, and each lookup either returns a code or #N/A. Sometimes only 1/4 lookups will give a value, sometimes 2 = value and 2 = #N/A, sometimes 3 = value and 1 = #N/A. However, within the same row it will always be the same value: <TABLE style="WIDTH: 192pt...

Hi everyone, I'm using Excel 2007 and I've tried a lot of different methods including VLookup and Match to solve this problem, but nothing is working. I have data like this: A B C 1 12/10/2002 10/9/2003 Period (dec. 10, 2002 - oct. 9...

I am an extreme beginner when it comes to Excel programming, so I was wondering if someone could help me. I am getting a CSV file from a web site which has columns of text values. Let's say one has A-Z. I have a worksheet that has 2 columns where if a1 is the value A, A2 is Andrew, b1 = B, b2 =...

Heloo all i need a quick solution to a very anoying problem...... i have i long sheet full of details as follows: a1 = name b1 = department c1 = school qualifications d1 = diplomas e1 = certificates f1 = further........ and so on.... with about 800 people in this sheet at any one time i don't...

Here is my problem... I have simplified my excel pages as much as I can to make this issue easy but I am left with one last column I cannot complete. I need to return only the values in a set number of cells in a larger range (always counting and including the cells starting from left to...