Posted to microsoft.public.excel.worksheet.functions

Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline

external usenet poster

Posts: 1,045

Lookup against concatenated source value

On Mon, 13 Feb 2012 14:45:50 -0800 (PST), Pete wrote:

Thank you Ron, and JulieD
I took advice from both of your posts, JulieD by removing the
concatenate, and Ron Rosenfeld and JulieD by reconfiguring the lookup
table. It's behaving now. It's nice to have smart people help.

Thank you both.

Glad to help. Thanks for the feedback

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
Changing Source Data using V-lookup	Kevin	Excel Worksheet Functions	2	April 14th 10 08:14 PM
Source for General V LookUp Tutorial??	ConfusedNHouston	Excel Worksheet Functions	3	June 6th 08 12:50 AM
concatenated lookup?	BorisS	Excel Worksheet Functions	7	December 13th 06 06:57 PM
Lookup for concatenated data	Hari	Excel Discussion (Misc queries)	2	May 20th 06 05:52 PM
how to lookup one source with alot of table array?	Winson	Excel Programming	1	January 19th 06 11:13 PM

All times are GMT +1. The time now is 06:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us