Results 1 to 4 of 4

Thread: Help! Withexcel conditional formula

  1. #1

    Help! Withexcel conditional formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there, hope someone might help me out with this formula im trying to write.
    (Excel_2013)

    I have 2 Sheets.
    Sheet 1 has 2 colums. Colum#1 are acronyms, Colum#2 is emply
    Sheet 2 has 2 colums. Colum#1 are acronyms, Colum#2 are the corresponding acronym's_fullname.

    So,

    In sheet 1, Colum#2 i need the corresponding acronym_fullname of that shown in colum#1(sheet1), as it show in Sheet 2.

    Thanks,
    BS.

  2. #2
    Try

    =VLOOKUP(A2,Sheet2!A:B,2,False)

  3. #3
    Quote Originally Posted by Bob Phillips View Post
    Try

    =VLOOKUP(A2,Sheet2!A:B,2,False)


    Hi Bob,

    Thanks man, already found this

    =INDEX(Sheet2!B:B,MATCH(A2,Sheet2!A:A,0))

    worked perfect. thanks anyway. gonna try that one too.

    BS.

  4. #4
    They should both work. VLOOKUP only looks right, whereas the INDEX/MATCH combo can lookup right or left, so it is more versatile, but of course it is 2 function calls as against 1.

Tags for this Thread

Posting Permissions

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