Results 1 to 7 of 7

Excel 2007 : Vlookup -New Excel 2007 User

Threaded View

  1. #1
    Registered User
    Join Date
    04-27-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    10

    Vlookup -New Excel 2007 User

    Hey i am a new Excel 2007 user.
    I am using VLOOKUP function as follows-
    VLOOKUP(A3,'History'!$B2:$E2000,2,FALSE)

    Here I want to replace value "2" in "$B2" dynamically such that the new value which is available in a different cell can replace it. Suppose cell P22 has value 46, so dynamically my function becomes
    VLOOKUP(A3,'History'!$B46:$E2000,2,FALSE)


    Thanks.
    Last edited by zitu708; 04-27-2010 at 09:40 AM. Reason: New Member, Title needs revising.

Thread Information

Users Browsing this Thread

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

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