VLookup

[pcw]

I am using the VLOOKUP function in the following manner ...

=DATE((VLOOKUP("ReferenceYear",EDRInput!A1:B498,2,FALSE)),
VLOOKUP("ReferenceCycle",EDRInput!A1:B498,2,FALSE),1)

I need to know what versions of Excel and what combination
of Operating System it works with.

Thanx.

 

[Frank Kabel]

Hi
should work with Excel 97+

 

[Bob Phillips]

Best way with these things is to build it on the lowest version you will be
deploying on, and then migrate to later versions.

--

HTH

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

 

[Patrick Molloy]

Note that this function raises an error if there is no match. One solution
is to use
On Error Resume Next before the function This means the error trap will have
to be reset afterwards.
l prefer to wrap these functions in my own function, in which l do the error
trap. Then l can have the function return a zero or a -1 to indicate no
match ...and then my regular error handling is not broken.