+ Reply to Thread
Results 1 to 10 of 10

Vigenere Cipher - Encryption is tricky

  1. #1
    Registered User
    Join Date
    01-21-2014
    Location
    London, England
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    11

    Vigenere Cipher - Encryption is tricky

    Hi, I'm working on a vigenere cipher in excel. I have my vigenere square, keyword, and plain text already.

    I do not know how to refer my text to the vigenere square. I think I have to use the 'MATCH' function. Though I have no idea how to use it in this situation.

    Please see the document attached.

    Many thanks
    Attached Files Attached Files

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Vigenere Cipher - Encryption is tricky

    Hi and welcome to the forum!

    Forgive me, but for those of us not familiar with encryption, nor the layout of your attached workbook, would it be possible for you to clarify exactly what you require help on, which cells are of concern, and what your expected results are?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Vigenere Cipher - Encryption is tricky

    What and where are your desired ouputs?
    Quang PT

  4. #4
    Registered User
    Join Date
    01-21-2014
    Location
    London, England
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    11

    Re: Vigenere Cipher - Encryption is tricky

    Hi,
    The idea of the vigenere cipher is that you have two text strings; a message(plain text), and a keyword.
    To encrypt each letter, you use the vigenere square. The first letter of the message is 'E' - therefore we go to the 'E' column (cell F1)
    The first letter of the keyword is 'M' - so we go to the 'M' row (cell A14).
    We then use the square to find where the column and row intersect - this is in cell F14 - so the first letter of our encrypted message is 'Q'.

    This is my objective.

  5. #5
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Vigenere Cipher - Encryption is tricky

    So can you please give us your full expected ciphered result for Plain Text = "ENCRYPTION" with Keyword = "MONDAY"?

    Regards

  6. #6
    Registered User
    Join Date
    01-21-2014
    Location
    London, England
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    11

    Re: Vigenere Cipher - Encryption is tricky

    The expected result would be: QBPUYNFWBQ

  7. #7
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Vigenere Cipher - Encryption is tricky

    Maybe like this in attachment. Anyway, I think it is not able to convert it back to plain text
    Attached Files Attached Files

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Vigenere Cipher - Encryption is tricky

    UDF?

    A
    B
    C
    1
    Plaintext
    ENCRYPTION B1: Input
    2
    Key
    Monday B2: Input
    3
    Encrypt
    QBPUYNFWBQ B3: =Vigenere(B1,B2)
    4
    Decrypt
    ENCRYPTION B4: =Vigenere(B3, B2, FALSE)


    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  9. #9
    Registered User
    Join Date
    01-21-2014
    Location
    London, England
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    11

    Re: Vigenere Cipher - Encryption is tricky

    OK, thanks for the assistance :-)

  10. #10
    Registered User
    Join Date
    01-21-2014
    Location
    London, England
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    11

    Re: Vigenere Cipher - Encryption is tricky

    Hi, I condensed the formula to this: =IF(AD13="","",INDEX($A$1:$AA$27,MATCH(AD11,$A$1:$A$27,0),MATCH(AD8,$A$1:$AA$1,0)))

    The encryption part of it is this: INDEX($A$1:$AA$27,MATCH(AD11,$A$1:$A$27,0),MATCH(AD8,$A$1:$AA$1,0))

    I think I will be able to decrypt this now so thanks for that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need to cipher a Text Box entry
    By saji in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2013, 03:06 PM
  2. Replies: 2
    Last Post: 11-04-2012, 06:35 PM
  3. doing a ceasar cipher excel project (need help with vlookup!)
    By indigo1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2012, 12:54 AM
  4. Venigére Cipher
    By PsychoSi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2012, 02:47 PM
  5. [SOLVED] How can I show the exact cipher that has 19 numbers in excel?
    By Alf in forum Excel General
    Replies: 1
    Last Post: 05-12-2006, 05:00 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1