Surely you just change B$1 to reflect which column you want ...or I am
missing something?

"anthony" wrote:

i currently been using the Vlookup function this way "
=VLOOKUP(pigs,'Coverage List'!$B$9:$S$5000,B$1,0)" wich has worked great. the
problem is that it only returns information up to 7 cells.( B1:H1)
and i need it to return cells b1:s1...can any one help?