• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

vlookup issue - formula is not working

Hello,

I hit a roadblock figuring out this vlookup formula.   It's not returning anything but the formula appears correct.

=VLOOKUP(H2, $A$2:$D$5, 4, FALSE)

I'm looking for the value in H2, selected the range, and column that I want to return, and looking for an exact match but when I hit enter, the formula doesn't respond.

Any insight or tips would be greatly appreciated.  I'm attaching a sample excel file of what I'm trying to do.  

thanks for your help!

lcha
example.xlsx
0
lcha
Asked:
lcha
  • 2
1 Solution
 
redmondbCommented:
Hi, lcha.

The problem is that the cell with the formula is defined with a format of "Text", which disables any formula. In the attached, I changed the cell's format to "General", re-entered the formula and copied it down.

Regards,
Brian.example-V2.xlsx
0
 
lchaAuthor Commented:
Perfect, thank you!
0
 
redmondbCommented:
Thanks, lcha!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now