MICROSOFT EXCELL

[JOSH]

HOW DO I USE MICROSOFT EXCELL TO LINK TWO DIFFERENT
WORKBOOKS TOGETHER USING THE VLOOKUP COMMAND? THE TRICK
IS THE TABLE THAT I AM USING FOR MY TABLE ARRAY IS NOT IN
ASCENDING ORDER. IT CANNOT BE BECAUSE OF THE WAY THAT
OUR WORKBOOK IS SET UP. CAN SOMEONE PLEASE HELP ME WITH
THIS. I NEED TO KNOW IF I HAVE TO UPDATE MY EXCELL OR IF
I CAN USE THE XP VERSION THAT CAME WITH MY COMPUTER.

 

[Bob Phillips]

Josh,

Please tone down the capitals!

Here is an example of VLOOKUP into another workbook, with the target table
not in order

=VLOOKUP("Aston Villa",'[Premiership 2003.xls]League
Table'!$B$3:$Z$22,25,FALSE)

'[Premiership 2003.xls]League Table'!$B$3:$Z$22 defines the workbook and the
table range

,FALSE specifies that it does not need to be in order as it seeks an exact
match

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

=Vlookup(A1,'[ABCD.xls]Sheet1'!A1:F30,3,False)

does an exact match and does not require the data to be sorted.

Behavior of Vlookup has not changed - so any recent version of Excel should
suffice.