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!
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!