Vlookup won't work

[Solved/Closed]
Report
Posts
3
Registration date
Friday March 20, 2015
Status
Member
Last seen
April 2, 2015
-
Posts
3
Registration date
Friday March 20, 2015
Status
Member
Last seen
April 2, 2015
-
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 reply

Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
Cookie5, Good Evening.

Try to use:

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

Is this what you want?
I hope it helps.
Posts
3
Registration date
Friday March 20, 2015
Status
Member
Last seen
April 2, 2015

That is exactly what I needed! Thank you so much for the help. That solved a very BIG problem for us.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!