Posted to microsoft.public.excel.programming

mvyvoda

external usenet poster

Posts: 41

VLookup Question

when using VLookup, how can I search not the entire cell but parts of the
cell, that is if I want to search 4 or 5 deep. If I'm comparing, for example:

A = 123456789
B = 1234d56789

VLOOKUP(A,B,1,???) - whereas ???=FALSE to find an exact match I would want
something to search B up to 4 or 5 characters compared to A.

Does this make sense?

Thanks for the help,
-m

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 question	Craig	Excel Worksheet Functions	3	February 7th 09 09:38 PM
Vlookup question	thedr9wningman	Excel Worksheet Functions	0	February 7th 09 04:35 AM
Vlookup question	Daniel	Excel Worksheet Functions	9	August 26th 08 01:50 PM
vlookup question	Mark	Excel Worksheet Functions	2	October 13th 06 05:12 PM
VLOOKUP question	jspizman	Excel Worksheet Functions	3	January 22nd 06 09:10 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us