Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem with vlookup
Hi,
Column A1:A10 has the numbers 10-1 and B1:B10 has price of a stock. Problem when I lookup the number = 12, it returns always the value in cell A10. Vlookup(12, A1:B10,2)=Value in cell B10, But A10 = 1, and this is not close, I want the closest number which would be 10, the value in cell A1. Is there any way to do this? Thanks for your help |
#2
|
|||
|
|||
type
=vlookup(12,a1:B10,2,false) it will give #N/A becaue there is no number as 12 in column A. Jeff wrote in message ... Hi, Column A1:A10 has the numbers 10-1 and B1:B10 has price of a stock. Problem when I lookup the number = 12, it returns always the value in cell A10. Vlookup(12, A1:B10,2)=Value in cell B10, But A10 = 1, and this is not close, I want the closest number which would be 10, the value in cell A1. Is there any way to do this? Thanks for your help |
#3
|
|||
|
|||
=vlookup(match(12,a1:a10,1),a1:b10,2,false) -- dcronje ------------------------------------------------------------------------ dcronje's Profile: http://www.excelforum.com/member.php...fo&userid=5281 View this thread: http://www.excelforum.com/showthread...hreadid=320595 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 hyperlink problem | Links and Linking in Excel | |||
Problem with date base units for x axis | Charts and Charting in Excel | |||
Problem drawing lines on charts | Charts and Charting in Excel | |||
Hyperlink to word document problem | Links and Linking in Excel | |||
Problem with Query | Links and Linking in Excel |