Posted to microsoft.public.excel.worksheet.functions

dmexcel

Posts: n/a

cursed vlook-up

I am trying to find a way to do this:
I have multiple contitions(5) so to get a match I have put the cells
together such as =g1&h1&i1&....
in another sheet I have put, the query and at the bottom I have
=a1&a2&a3&...
when these great great;
I would like to get a match or the next highest number from column g
thanks
Andy

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
Subject: vlook up 1/25/2006 1:39 PM PST	arcticale	Excel Discussion (Misc queries)	1	January 27th 06 06:10 PM
vlook up	arcticale	Excel Discussion (Misc queries)	1	January 25th 06 09:36 PM
vlook up	Sean	Excel Worksheet Functions	1	July 14th 05 11:04 PM
How do I use drop down list selections/values in a vlook up formu.	CL	Excel Discussion (Misc queries)	2	January 19th 05 10:39 PM
"Vlook up + IF"	paula smith	Excel Worksheet Functions	2	November 28th 04 03:20 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us