How can I make results of a formula values that can be filtered or use vlookup?
Here are 17 best answers to ‘How can I make results of a formula values that can be filtered or use vlookup?’  the most relevant comments and solutions are submitted by users of Excelforum.com, Yahoo! Answers and Ask.Metafilter.Com.
Best solution

Excel 2007 : How can I make results of a formula values ...
... How can I make results of a formula values that can be filtered or use vlookup; ... or a vlookup with the results. I can’t do this because as an example ...
excelforum.com
Other solutions

I NEED help. I'm going to fail math if I dont get help =( (long)?
This is the notes and the assignment she gave us and I have NO clue where to begin or what I'm even supposed to do. PLEASE help me so I don't fail. please btw the graphs and circles they speak of arn't showing = / In algebra we call the relation between...
Answer:
Your graph shouldn't produce a circle because of the limitations produced by the second equation. But...

Conditional Formula Selection in Excel
How can I create an Excel worksheet which uses something like VLOOKUP (or anything which works in a similarish way) not to pull values, but formulas? So, here's the situation: I'm trying to make a single billing Excel sheet where I can keep track of...
Answer:
See here. You'd have to use a very light bit of VBA to do this. Just add a VBA function that looks like...

Hi Having a bit of a problem with printing with Excel. I have itemised the area on the worksheet I want to print and it is a single page. When I print the page and also when Preview the page it only prints or displays the top 2/3 of the required info...
Answer:
Eric, Highlighting an area is the first step. You must then select that area as the print area. Inversions...

QUESTION: I need to build a proposal template that will continually reference an item list on either a separatefile or simply an additional worksheet within the same workbook. Preferably a separate file, however I will take whatever I can get. My first...
Answer:
Steve Contextures is a great site; lots of good information. The link to another workbook should look...

QUESTION: this is the code I am having problems with. Sub ScrollScores() Dim r As Range, cell As Range, ii As Long, i As Long Dim sh As Worksheet, v As Variant, idex As Long Dim vv As Variant vv = Array(1, 4, 1, 1) 'for example v = Array("Net"...
Answer:
Alan, My error. Changed my mind on implementation and didn't get everything revised. Sub ScrollScores...

QUESTION: I am using2007 ThroughVisual Basic I need to go to http://www.google.com/finance/historical?q=AAPL&startdate=Nov+18%2C+2008&enddate=Nov+19%2C+2009&num=30 but I would like the link to change based on the text of specific cells...
Answer:
My answer was not intended as the entire code. In your original question, you already had Set IE =...

This is to request you to please guide me how i can use if function in the following cells to get accurate value. A=Single Then B1 should contain value from C1=3000 and if A1=2(6w)or 3(6w)or 4(6w) then B1 should contain value from D1=what ever in D1...
Answer:
You can use the IF formula in combination with the logical formula OR. Something like: =IF(A1="...

Hi i have a spreadsheet with a column with 10 rows. data will be entered in all the odd numbered rows, and will then total in a box at the bottom. the even numbered rows are filled in at a latter date, and i need the sheet to total these, superceding...
Answer:
Harry Assuming that all your values are positive, if filled in, and if I understand correctly what...

QUESTION: I have a spreadsheet I use as an employee schedule. On the bottom of the sheet for each day there is a list of available shifts for that day. One day of the week we need two "G" shifts. I use conditional formatting to find duplicates...
Answer:
Angela > When I entered the formula that you gave me it only seemed to highlight the third entry...