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

Mazzaropi Posts 1985 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.
0