Results 1 to 2 of 2
  1. #1
    metokushika is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2011
    Posts
    19

    understanding excel for access purposes


    hi. i need to make a form in access related to the records from excel. i need the operations to be exactly the same from excel so i could convert the calculations in ms access. but i don't know what this means? =(IF(ISNA(VLOOKUP(G12,$AI$9:$AJ$10, 2, 0)),0,VLOOKUP(G12,$AI$9:$AJ$10, 2, 0))) it's from one of the calculations in excel. i just want to understand what the logic is about. any help would do! thanks!

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,524
    If the value from this lookup is NA, return a 0, otherwise return the value from the lookup.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. ADODB Recrodset (Understanding)
    By danny2000 in forum Access
    Replies: 3
    Last Post: 07-12-2011, 06:00 AM
  2. Help Understanding Join Syntax In Access
    By zephaneas in forum Queries
    Replies: 5
    Last Post: 06-22-2011, 08:32 PM
  3. Understanding afterupdate
    By MAM8433 in forum Access
    Replies: 8
    Last Post: 05-23-2011, 02:05 PM
  4. Not understanding Running Sum Query
    By dynamictiger in forum Queries
    Replies: 4
    Last Post: 08-30-2010, 11:50 AM
  5. Understanding SQL Querys
    By jacobbiljo in forum Access
    Replies: 8
    Last Post: 11-17-2009, 05:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums