lookups

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Keith (kgoshia_at_msn.com)
Date: 07/26/04 

Date: Mon, 26 Jul 2004 09:24:33 -0700

I am needed a little help. I am trying to use a lookup
statements that copies values out of one spread sheet over
to another. How do I do this? The numbers I am trying to
move from one location to another are values. So a simple
copy/paste does not work. I have to do a special paste
and choose value.

Keith

Relevant Pages

  • Re: Comapring fields that have TXT and Nos
    ... The lookup table can be anywhere in your spread sheet. ... In the lookup formula the first cell reference is the one you are ... When entering the data that you want to look up the description for, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: LOCATE vs. LOOKUP
    ... Keith G Hicks wrote: ... > For example in areas where I have a data set in a data module and use ... > it to lookup information sometimes. ...
    (borland.public.delphi.database.ado)
  • RE: VLOOKUP returns #REF!
    ... And the second file in your lookup must be opne ... "AdamV" wrote: ... first column of that spread sheet, but I can't get it to work. ...
    (microsoft.public.excel.worksheet.functions)
  • Look up dates
    ... I have a spread sheet that contains dates, ... I want to be able to lookup all games that were played on a certain day ... Alan ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Help with syntax for passing a field value to a lookup query?
    ... Keith ... >I trust you are not attempting to create lookup fields in a table design. ... > You can and should use lookups (combo boxes) on forms. ... >> combo box to display only Phoenix and Tempe... ...
    (microsoft.public.access.tablesdbdesign)