V Lookup in Excel

  oo7juk 15:38 16 Mar 06
Locked

Hi,

I have tried to update an excel workbook, the v lookup page. Unfortunately when I input the new details in the workbook it does not trigger the additions that I've made. Is there anyway I can edit the original table to accept changes.

Many thanks.

  VoG II 15:44 16 Mar 06

You need to edit the VLOOKUP formula to refer to the whole of the data that you want to lookup from.

  oo7juk 15:57 16 Mar 06

Tried to do that VoG but couldn't see anything like a1 to c10 then edit to read a1 to c12.

The following are taken from the spreadsheet:

=VLOOKUP(F1334,gvw,4)

=LOOKUP(F1334,'domestic route tonnages.xls'!Tare)


Thanks.

  VoG II 16:07 16 Mar 06

I am assuming that gvw and Tare are named ranges - thus the first formula is looking up the value in F1334 in the 4th column of the range gvw.

You will need to change the named range. Insert > Name > Define, click on gvw and change what is in the Refers to box to the range that you want to lookup from.

Your second formula seems to be missing the third parameter:

=VLOOKUP(parameter1, parameter2, parameter3, parameter4)

parameter1 = value to lookup

parameter2 = range to look in

parameter 3 = column number in the range to lookup

parameter4 (optional) = True to find the nearest match or False to find an exact match.

  oo7juk 14:02 17 Mar 06

VoG,

Have changed the named range but still isn't doing what I want. For your information I didn't create this spreadsheet so I don't know if that would cause any problems and I've never created a spreadsheet with the look up function.

Many thanks,

  VoG II 19:24 18 Mar 06

Without knowing something about how the spreadsheet is structured, it really isn't possible to advise further, oo7juk.

Did it work before you added stuff to the spreadsheet? Did you make a backup copy before changing the file?

If it isn't top secret or commercially sensitive I can take a look at the file - click my yellow envelope to send me an e-mail if you wish to do this.

This thread is now locked and can not be replied to.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced