Results 1 to 2 of 2

Thread: If and Vlookup question

  1. #1

    If and Vlookup question



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

    Hi there.

    I am very stumped by what I thought should be simple.

    On a sheet I have a column with item names in and in the next column 'True' or 'false'

    I just want a Vlookup I guess that looks at the second column, determines if it says true, and if so return the contents of column one

    No matter what I do though, for some reason it simply returns the answer 'false'

    My formula basically looks like, if(X="TRUE",Vlookup(X, range, index no)

    If anyone could offer a hint as to what I am doing I would appreciate it!

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    772
    Articles
    0
    Excel Version
    2010
    I can't be sure without seeing your spreadsheet, but try removing the quotes around "TRUE".

Posting Permissions

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