Results 1 to 4 of 4

Dynamic Referencing

Threaded View

  1. #1
    Registered User
    Join Date
    10-14-2009
    Location
    Denver, CO
    MS-Off Ver
    Excel 2010
    Posts
    7

    Dynamic Referencing

    This should be a fairly easy one, but for some reason I can't get it to work for me.

    I have a worksheet titled "Systems Estimate" that will dictate values on a second worksheet called "CSI Estimate". They're the same values in each cell and column, just in a different order row wise.

    I would like the values in each row in the A column in the "CSI Estimate" sheet to dictate columns B through W, with the values being referenced from the "Systems Estimate" sheet.

    I tried using an exact match with vlookup since the data isn't sorted, however it just returns the formula I enter, not a value.

    Please advise if you have any thoughts. Thank you in advance; I greatly appreciate it.
    Last edited by cuclay; 12-02-2009 at 11:21 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1