Jeff

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003 hyperlink problem	GregL	Links and Linking in Excel	0	January 16th 05 04:03 AM
Problem with date base units for x axis	Peter Carr	Charts and Charting in Excel	1	December 15th 04 09:11 AM
Problem drawing lines on charts	Susan Lambert	Charts and Charting in Excel	7	December 13th 04 08:29 AM
Hyperlink to word document problem	JS	Links and Linking in Excel	0	December 8th 04 10:54 PM
Problem with Query	John	Links and Linking in Excel	4	December 7th 04 02:49 PM

All times are GMT +1. The time now is 03:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us