Find solution

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

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

    Mark as irrelevant Undo
  • 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...

    Mark as irrelevant Undo
  • Excel

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

    Mark as irrelevant Undo
  • Reference data within

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

    Mark as irrelevant Undo
  • Auto scroll results

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

    Mark as irrelevant Undo
  • Vba

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

    Mark as irrelevant Undo
  • About excel...

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

    Mark as irrelevant Undo
  • Excel formulas

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

    Mark as irrelevant Undo
  • Conditional formatting

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

    Mark as irrelevant Undo