thank you all for pinpointing my stupid mistake!

after adjusting my array ref to 2 col ($a$1:$b$6) the formula works
nicely!

thks again!

-via135



Pete Wrote:
Your table is only one column wide ($A$1:$A$6), yet you are trying to
get data from the second column. I suggest you change the formula to:

=(VLOOKUP(A1,Sheet7!$A$1:$B$6,2,FALSE))

Hope this helps.

Pete


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=508493