Posted to microsoft.public.excel.worksheet.functions

Lloyd

external usenet poster

Posts: 41

vlookup puzzle

I have a 12 digit number in one area and doing the vlookup seems to be only
looking at the first 6 and rouding at that point. I need the lookup to look
at the entire 12 characters and do a match on all 12.

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
Pivot Puzzle	Wanna Learn	Excel Discussion (Misc queries)	3	November 1st 07 12:11 AM
A real puzzle?	paulsuk	Excel Discussion (Misc queries)	7	March 7th 07 07:27 PM
VLOOKUP puzzle ??	Anthony	Excel Worksheet Functions	8	November 29th 06 05:49 PM
Excel Puzzle	dwalesb	Excel Worksheet Functions	2	January 26th 06 06:27 PM
Can you help!!!!! New Puzzle	Krefty	Excel Discussion (Misc queries)	0	June 13th 05 08:13 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us