Previous Topic Next Topic

Vlookup won't work

Solved/Closed
Cookie5 Posts 3 Registration date Friday March 20, 2015 Status Member Last seen April 2, 2015 - Apr 1, 2015 at 02:02 PM
Cookie5 Posts 3 Registration date Friday March 20, 2015 Status Member Last seen April 2, 2015 - Apr 2, 2015 at 09:13 AM
I am trying to set up a formula in Excel 2013 that says to look at what is in X11, find the title and explanation in a group of cells on another worksheet, and put the explanation in X10.
What I have is =VLOOKUP(X11,Categories!,A3:B233,2,false)
Categories is the worksheet the information is on.

What am I doing wrong? Excel isn't even giving me an error message that might help me figure this out. I'm really stuck.

Many thanks to everyone.

1 response

Answer 1 / 1
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 1, 2015 at 08:27 PM
Cookie5, Good Evening.

Try to use:

=VLOOKUP(X11,Categories!A3:B233,2,false)

Is this what you want?
I hope it helps.
Cookie5 Posts 3 Registration date Friday March 20, 2015 Status Member Last seen April 2, 2015
Apr 2, 2015 at 09:13 AM
That is exactly what I needed! Thank you so much for the help. That solved a very BIG problem for us.

Similar discussions

How to invoke VLookUp function in Excel VBA.
Wingie -
TrowaD -

1 response
Removing "FALSE" from an IF statement with a VLOOKUP
RayRay -
RayRay -

2 responses
Comparing columns and returning value
ll -
kittu -

35 responses
Excel 2007 Using vlookup function in VBA
gsyrill -
gsyrill -

2 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses