If and Vlookup question

garethi

New member
Joined
Oct 3, 2013
Messages
1
Reaction score
0
Points
0
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!
 

Hercules1946

New member
Joined
Mar 22, 2013
Messages
794
Reaction score
0
Points
0
Location
York, England
Excel Version(s)
2010
I can't be sure without seeing your spreadsheet, but try removing the quotes around "TRUE".
 
Top