Des

Posts: n/a

How do I lookup a corresponding value in another table

I am trying to create a lookup where I am entering a 6 account number digit
but my 2 col lookup database has 16 number digits in col 1. I want my
lookup to ignore the last 10 digits in this table and give me the
corresponding text from col2 in table.

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
How to create a lookup table with an added varable?	GIZZMO	Excel Worksheet Functions	3	April 6th 09 10:32 PM
Lookup table?	Peter	Excel Discussion (Misc queries)	1	September 17th 05 08:02 PM
Lookup Table Dilemma	Karen	Excel Worksheet Functions	2	June 10th 05 08:22 PM
Multiple table lookup	KG	Excel Discussion (Misc queries)	1	June 3rd 05 05:39 AM
How do I lookup a table from right to left ?	Daz9	Excel Worksheet Functions	1	April 11th 05 11:21 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us