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
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