If that's the way the formula looks (just the worksheet name), then it really
isn't used as a worksheet name--it's just coincidence that someone used:

Insert|Name|define
and decided to use the name of an existing worksheet.

My guess is that you didn't create that name in the new workbook.



BROCK8292 wrote:

THANK YOU, THAT WAS VERY HELPFUL
WHEN I WAS SENT THIS FORMULA IT LOOKED LIKE THIS
=VLOOKUP(A1,WORKSHEET NAME,4)
BUT MY FORMULA IS IDENTICAL TO WHAT YOU SENT ME W/O THE $
DO YOU KNOW WHY THE FIRST FORMULA WILL ONLY WORK IN THE WORKSHEET IT WAS
SENT TO ME IN AND NOT ONE THAT I CREATE?

"Dave Peterson" wrote:

if you're =vlookup() formula looks like:

=vlookup(a1,sheet2!a1:b9,2,false)
you could use
=vlookup(a1,sheet2!$a$1:$b$9,2,false)
so that $a$1:$b$9 range won't change if you copy/move that formula.

But you could also do something like:
=vlookup(a1,sheet2!a:b,2,false)
(if there's nothing under that table that would bother the =vlookup() formula)


BROCK8292 wrote:

WHEN I COPY A VLOOKUP FORMULA THE CELL RANGE IS AUTOMATICALLY ADJUSTED. IS
THERE A WAY TO USE VLOOKUP WITH AN ENTIRE WORKSHEET AS THE RANGE THAT I WANT
IT TO SEARCH AS OPPOSED TO REFERENCING A SERIES OF INDIVIDUAL CELLS?

--

Dave Peterson


--

Dave Peterson