A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Vlookup Returning Same Results on Each Row



 
 
Thread Tools Display Modes
  #1  
Old December 14th 05, 07:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
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.

Ads
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP not returning results Chris Kellock Excel Worksheet Functions 14 March 19th 08 08:30 AM
abdualmohsn almedrahe abdualmohsn ahmad Excel Discussion (Misc queries) 1 November 19th 05 06: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 11:21 AM


All times are GMT +1. The time now is 02:57 PM.


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