Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kleev
 
Posts: n/a
Default Vlookup Returning Same Results on Each Row

Sounds like Calculation mode has been changed to manual. Either change it
back to automatic or hit F9 to recalculate.

"tlatta" wrote:

Using this formual to find enter a tracking number to an order number.

=VLOOKUP(A2,Sheet2!$A$2:$B$287,2,FALSE) where A2 is the order number and
Sheet 2 A and B are the order numbers and tracking numbers

The problem is, it gives me the correct answer for the first cell and when I
copy it down it just repeats that same number? If I actually click on the
formual for the next cell and then hit enter (not changing anything) it then
returns the correct tracking number? Do I have this fomated incorrectly?
Any help would be appreciated, otherwise I need to click on 2000 formuals
and hit enter.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP not returning results Chris Kellock Excel Worksheet Functions 14 March 19th 08 09:30 AM
abdualmohsn almedrahe abdualmohsn ahmad Excel Discussion (Misc queries) 1 November 19th 05 07:32 PM
format cell based on results of vlookup function Edith F Excel Worksheet Functions 1 July 21st 05 07:39 PM
vlookup returning a n/a result jeanette.rimmer Excel Worksheet Functions 4 July 14th 05 01:00 AM
MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. Martin Excel Discussion (Misc queries) 2 December 13th 04 12:21 PM


All times are GMT +1. The time now is 12:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"