You can use column() function instead of hard coding column number. Just use this function in Vlookup function. and also you shd subtract no.of columns from first column to first column of your array.
=vlookup(b1,test!b1:bz100,column(test!d1)-1)