I'm an experienced Excel user, and have run into something beyond strange. My
vlookups (whether manually entered or run as part of an existing macro) will
now ONLY return the looked-up value for the first entry when I drop OR paste
the contents of the first cell down.

FOR EXAMPLE: If I have two sheets - one with names and phone numbers and one
with names and birthdays, and i try to do a vlookup on name between the two
sheets, it looks like this:

Sam 3/29/78 414-323-4132
Sally 5/23/68 414-323-4132
Tara 2/2/34 414-323-4132

I can then continue to paste the copied (original) formula beside blank
cells, and it will still continue to return the 414-323-4132 number.
STRANGE! - and FRUSTRATING!!!

Can someone help? Is there a setting I've inadvertently clicked? I've
already verified data types, forms, etc...the standard stuff. I've also shut
down/restarted, etc...nothing. I know it's not the reports b/c the VLOOKUP
works on other computers on the same reports. WHAT DID I DO?!?


--
Thank you! - Jennifer