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
Vlookup if cell contains a word within text ✓ - Word Forum
Vlookup false ✓ - Excel Forum
Vlookup if two cells match return value from third ✓ - Excel Forum
Help Please IF & VLOOKUP Returns - 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

Comparing columns and returning value

Match partial text string in one sheet to another text string in another sheet

Lookup partial text contained in cell range

Using Vlookup to return insted of 00/01/1900

add/subtract & vlookup formula

Similar discussions

Subscribe To Our Newsletter!