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
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.
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.
Related:
- Vlookup won't work
- Excel iserror vlookup - Guide
- 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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 1, 2015 at 08:27 PM
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.
Try to use:
=VLOOKUP(X11,Categories!A3:B233,2,false)
Is this what you want?
I hope it helps.
Apr 2, 2015 at 09:13 AM