Solved

Vlookup - query

Posted on 2014-04-25
2
194 Views
Last Modified: 2014-04-25
Hello

Can someone tell me why in the attached document sheet 2 cell F5 is not returning the value of 1 (relating to sheet 1 cell c8) when using the vlookup function?

Thanks
Rob
Excel-question---vlookup.xlsx
0
Comment
Question by:rob700
2 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 40022580
Your lookup table range in the formula was column A only, should be minimum A:C  since you want the 3rd column data

=VLOOKUP(C5,Sheet1!A:C,3,FALSE)
0
 

Author Comment

by:rob700
ID: 40022659
Fantastic, stupid mistake.

Thank-you!
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now