• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Vlookup Error

J

jrl1208

Member
Hi


I have a problem with excel vlookup, when I insert a vlookup formula in my spreadsheet in Cell B3:B7 It will just pick up first answer all the way through. When I double click each indivual cell the answer will change to the correct one.


Please refer to below example: B4 should be 15 and B5 should be 20 etc.....

I don't understand why excel is doing this.


Example

Colour No

Red 10

Blue 10

Pink 10

Blue 10

Green 10


Data

Red 10

Blue 15

Pink 20

Green 5


Appreciate any assistance.
 
Hi,


Please check your recalculation mode, it could be on manual. If so switch it to automatic
 
Yes for some reason my recalculaton mode was set to manual. I've fix the problem. Thank-you for your help
 
You must log in or register to reply here.
Back
Top