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 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.
0
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

Similar discussions

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

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

11 responses
Concanating text using vlookup forumula
gannesh0604 -
gannesh0604 -

0 responses
Conditional Formatting in a vlookup
attycuz -
TrowaD -

1 response
Find missing data in 2 columns (Excel)
dalami81 -
dalami81 -

2 responses