Posted to microsoft.public.excel.programming

Steph

external usenet poster

Posts: 46

Vlookup Limitations

Hi all. Does anyone know if there are character limitations on Vlookup or
Sumif formulas? I have a file where the cell I am looking up is quite long.
And I seem to recall a while back that vlookup only reads the first x
characters in the lookup cell. Is this true? Thanks for youe 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
vlookup character limitations	808bobby	Excel Worksheet Functions	1	February 18th 10 11:30 PM
vlookup size limitations search range?	Hans	Excel Worksheet Functions	4	February 19th 08 07:34 AM
vlookup limitations?	Larry[_5_]	Excel Worksheet Functions	10	December 14th 07 02:09 AM
VLOOKUP Limitations	chris_manning	Excel Worksheet Functions	2	August 9th 05 06:23 PM
Vlookup limitations	Dahlman	Excel Worksheet Functions	3	November 19th 04 02:13 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us