VLookup
 

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.

VLookup
 

Hi
should work with Excel 97+

--
Regards
Frank Kabel
Frankfurt, Germany

"pcw" schrieb im Newsbeitrag
...

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.

VLookup
 

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)

"pcw" wrote in message
...

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.

VLookup
 

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.
--
Patrick Molloy
Microsoft Excel MVP

"Frank Kabel" wrote in message
...
Hi
should work with Excel 97+

--
Regards
Frank Kabel
Frankfurt, Germany

"pcw" schrieb im Newsbeitrag
...

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.