I am trying to use "&" in a vlookup to do a lookup on a differant sheet that is listed in cell B1, the formula I created is =VLOOKUP(A7,"Sheet"&B1&"!"&"A1:J40",5,0), "Sheet"&B1&"!"&"A1:J40" = Sheet48!A1:J25 (with 48 in cell B1) which is exactly what it should be. But it returns #VALUE! error. What am I doing wrong?
Thanks, for any help
Thanks, for any help