Posted to microsoft.public.excel.worksheet.functions

Ruth

external usenet poster

Posts: 132

vlookup and lookup

I'm using a simple 2 column table with either vlookup or lookup function and
some of the return values are the row above. I realize if it doesn't have an
exact match it will return the next largest value that is less so I used the
Round function to make sure there would be exact matches. What am I missing?
--
Ruthie

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
About Lookup and Vlookup	Maria	Excel Discussion (Misc queries)	3	October 30th 08 04:40 AM
=IF(AND(LOOKUP(F3,A21:A42)=F3,LOOKUP(B4,B21:B42)=B4),(VLOOKUP(B4,B	RWD715	Excel Worksheet Functions	9	October 10th 08 10:11 PM
lookup or vlookup	[email protected]	Excel Worksheet Functions	7	July 28th 08 11:53 PM
Lookup without VLOOKUP?	J	New Users to Excel	6	November 17th 05 06:57 AM
LOOKUP or VLOOKUP	Bennie	Excel Worksheet Functions	4	March 24th 05 07:45 PM

All times are GMT +1. The time now is 08:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us