Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel look up issue

Status
Not open for further replies.

john434

MIS
Mar 17, 2004
50
GB
G'day,

is it possible to use a Look up function which contains year refs (01_02, 02_03 etc) to return all the values from the look up table that should contain more than one year ref.

cheers
 
???????

As a general note though, lookups only return ONE piece of data - that which either exactly matches or is the closest match to the value to be looked up - depending on the type of lookup you do

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top