Results 1 to 11 of 11

Thread: Help about dynamic value table array in Vlookup

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Help about dynamic value table array in Vlookup

    Hi there,
    I have stucked on Vlookup like the title.
    So example: I have an Excel file contains data to be searched by Vlookup as path: D:\Example\Data.xlsx.
    And I have an other Excel with cell B2 that contains value path of Excel data (D:\Example\Data.xlsx.).
    What i need is dynamic that B2 cell value into my Vlookup function formula,so I really dont know is there any formula in Vlookup to solved it. I tried as below
    =VLOOKUP(A3,INDIRECT(CONCATENATE(B2,"test'!$B:$L")),2,FALSE)
    But it does not work. I need all your help. Thank so much.
    Last edited by rong3; 10-18-2017 at 01:03 AM.

Posting Permissions

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