Cordell

Posts: n/a

MATCH Limitation?

I'm trying to look up lookup up some lengthy text values in a table. I'm
getting #VALUE! error messages when my lookup up text value is 255
characters. This appears to be an Excel limitation.

Can anyone confirm this and offer a potential alternative?

Thanks,

Cordell

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
Match Index	cjjoo	Excel Worksheet Functions	3	October 25th 05 09:33 AM
Look up data in colum a and find match in colum b	Chris(new user)	Excel Discussion (Misc queries)	1	March 22nd 05 01:41 PM
Look up data in colum a and find match in colum b	Chris(new user)	Excel Discussion (Misc queries)	1	March 19th 05 09:27 PM
Offset, indirect, match function limitation on linked worksheets.	NewAlgier	Excel Worksheet Functions	1	December 6th 04 11:55 PM
Find a match that;s not exact	Phyllis	Excel Worksheet Functions	0	November 8th 04 08:12 PM

All times are GMT +1. The time now is 01:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us