Posted to microsoft.public.excel.worksheet.functions

Landon C

Posts: n/a

Lookup problem

I have a table like this

a b c
6.75 -.75
6.875 -1.25
7.0 -2.0
7.125 -2.125
7.375 -2.75
7.5 -3.0

Everything works fine on my spreadsheet until I change from 7 to 7.125. It
returns the same value(-2.0). I don't know what I am doing wrong. Please help.
Landon

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
Range Lookup - Problem	Jose M via OfficeKB.com	Excel Worksheet Functions	0	August 9th 05 04:00 AM
Range Lookup - Problem	Jose M via OfficeKB.com	Excel Worksheet Functions	0	August 9th 05 04:00 AM
Range Lookup - Problem	Jose M via OfficeKB.com	Excel Worksheet Functions	0	August 9th 05 03:59 AM
Lookup Problem	Scott	Excel Worksheet Functions	0	April 18th 05 08:07 PM
Lookup Problem	Annette	Excel Worksheet Functions	1	April 16th 05 03:10 AM

All times are GMT +1. The time now is 05:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us