My HLOOKUP is not giving the answer I expect

**SparkleHedgehog** · 07-03-2013, 06:53 AM

I'm really struggling to work out why my Excel HLookup is giving me an incorrect figure.

I want to be able to search the A row for a text word and then extract the relevant row of data from that column once found.

In the example attached i have used the word CARD as an example for the text search which can be found in column A title. Then i want to retrieve the value from row 5 of the found column but for some reason it's giving me a value of 85 instead of the desired 92879.

I know it'll be my formula but i just cant see what's wrong with it. Please help me before i go nuts

Thank you in advance.

John
Screen Shot 2013-07-03 at 11.47.15.jpg

**Richard Buttrey** · 07-03-2013, 06:59 AM

Hi and welcome to the forum. Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Since this is your first post I'll change it for you but please remember for next time. You've also posted a picture which is generally frowned upon for the reasons mentioned in the forum rules.