Vlookup Data Range

[Nid_rvd]

Hi All,

Need a quick help on Vlookup. The data range i use for a vlookup, lets say A:C, with referece to column 3, data range A:C is renamed as "Forum", whereby the formula would look like =VLOOKUP(A1,Forum,3,0). However, I need the reference of "Forum" to be picked up from a cell (Lets say a formula =Clean(A3)) whereby the Vlookup formula is tweaked to contain the aditional formula. Expected output, something on the lines of (=VLOOKUP(A1,cell(D1),3,0), whereby the desired data range reference "Forum" is captured

 

[DILIPandey]

Hi Nid_rvd,

Try using Indirect function here.. something like =vlookup(a1,indirect(forum),3,0) or pick forum directly from cell a3 as =vlookup(a1,indirect(a3),3,0).


Regards,
DILIPandey