Results 1 to 3 of 3

Thread: Help with a formula

  1. #1

    Help with a formula

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

    Hi there,

    I have the attached spreadsheet and I need to get the value in column G to look at the list in column M and then return the value in column N to column H.

    I have tried various variations with LOOKUP and VLOOKUP with no luck.

    Please help, I'm trying to impress the Mrs!
    Attached Files Attached Files

  2. #2
    Good afternoon,

    Do you mean like this?

    In H4: =VLOOKUP(G4,M:N,2,FALSE)

    Let me know if I'm off. I may not be understanding correctly.

    Best of luck,

  3. #3
    That looks perfect! Thanks very much indeed. I think I was misunderstanding the column index and range lookup sections.

    Thanks again, your help really is appreciated.

Posting Permissions

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