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.

Vlookup won't work
Transfer data from one excel worksheet to another automatically vlookup - Guide
Excel 2007 Using vlookup function in VBA ✓ - Excel Forum
Using Vlookup to return insted of 00/01/1900 ✓ - Excel Forum
Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum

1 response

Answer 1 / 1

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.

Similar discussions

Compare values in two columns and return the value from third

VlookUp Problem?

Concanating text using vlookup forumula

Automatically transfer data from one sheet to another

Conditional Formatting in a vlookup

Similar discussions

Subscribe To Our Newsletter!