Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Weird Formula

  1. #1
    Guest

    Default

    I have a table
    ID Name
    -----------
    1 AAA
    2 BBB

    How do I write a formula such that

    When I enter ID in cell A1, cell A2 will be written with the appropriate name, or "Not Available" if the name is not available

    A2 = "=IF (A1........

    Thanks

  2. #2
    Guest

    Default

    Say your table is in the range F1:G10
    In A2, enter
    =IF(ISNA(VLOOKUP(A1,F1:G10,2,FALSE)),"Not Available",VLOOKUP(A1,F1:G10,2,FALSE))
    HTH
    Richard

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •