Desparate

Posts: n/a

LookUp - Exact only

I have a lookup function that works OK - but it returns the nearest when
there is no exact match. How can I make it only return exact matches and
leave a blank if there is no exact match.

Thanks in advance

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
LookUp - Exact only	Desparate	Excel Worksheet Functions	2	November 11th 04 09:52 AM
Excel Lookup Functions	Paul Adams	Excel Worksheet Functions	1	November 10th 04 02:40 PM
Vector lookup function	GregTh	Excel Worksheet Functions	1	November 5th 04 04:19 PM
Lookup, IF, Then help	CCDC	Excel Worksheet Functions	1	October 31st 04 01:33 PM
double lookup, nest, or macro?	Josef.angel	Excel Worksheet Functions	1	October 29th 04 09:50 AM

All times are GMT +1. The time now is 10:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us