I'm assuming you did not understand what I wrote earlier
Instead of B1=45; B2=46; B3=47 etc [45,46,47 being the worksheet names]
Do B1=45; B2=46; B3=47 etc [45,46,47 being the array names]
Just highlight the array of cells you want to reference, go to the top left corner of the page where the cell number is usually displayed and type in an array name.
EASY.
Then just use that array name in the vlookup statement as I explained earlier. Do you understand?
You cannot put the range of cells in the vlookup statement, you must put in the array name!
