Posted to microsoft.public.excel.worksheet.functions

carl

Posts: n/a

Vlookup Question

My lookup table is like this:

LookUpTable
OLAF0009
OLAF0050
OLAF0325

The data table looks like this:

DataTable
009F0OLA
050F0OLA
325F0OLA

Can a VLOOKUP compare the last 3 characters of the data table with the first
3 characters of the lookup table ?

Thank you 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
vlookup question	Greegan	Excel Worksheet Functions	3	December 20th 05 04:00 AM
VLOOKUP() Question... i hope	Adam Kroger	Excel Discussion (Misc queries)	2	November 29th 05 10:22 PM
Vlookup question please	Bob Newman	Excel Worksheet Functions	3	March 17th 05 02:17 PM
vlookup question please	Bob Newman	Excel Worksheet Functions	1	March 17th 05 06:25 AM
Vlookup against multiple columns/worksheets question	JCarter	Excel Discussion (Misc queries)	8	March 9th 05 04:59 PM

All times are GMT +1. The time now is 12:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us