none
Importing document to excel cell RRS feed

  • Question

  • I am importing a document in the following format (HyperText Transfer Protocol) to cell A1 in an excel spreadsheet. This document changes in size depending on the information (adds additional rows) so that I cannot reference a particular cell each time to extract the cell value. (i.e. the "valuation amount"  cell will always be in colmun "J" but row will change). The value I need is the cell to the right of my cell entitled "valuation amount". I have attempted Vlookup, Index, Match and combos of all - any suggestions?

    Valuation Amount: $7,297.04 Valuation Amount Variance: $307.40
    Actual Variance: $137.80

    Valuation Amount Accuracy (%):

    95.87%
    Wednesday, February 15, 2012 5:48 PM