V Lookup in Excel

  oo7juk 15:38 16 Mar 2006
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.

  oo7juk 15:57 16 Mar 2006

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.

  oo7juk 14:02 17 Mar 2006

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,

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

Elsewhere on IDG sites

What to do if you're affected by the Intel Foreshadow flaw

Illustrator Rose Blake gives a kid-friendly update for David Hockney's art guide A History of…

iMac at 20: 10 iMac facts and history in pictures

Comment afficher des sous-titres sur Netflix ?