Russ B

Posts: n/a

vlookup more than one exact match

For vlookup, If there are two or more values in the first column of
table_array that match the lookup_value, the first value found is used. I
have several matches for each lookup value. Which function/functions can i
use to show all the matches under each lookup value.

Thank ou in anticipation!
Russ

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
is there a way to search with vlookup to match more than 1 column	puppy	Excel Discussion (Misc queries)	7	June 30th 05 07:41 PM
using vlookup to find exact match	Janice Lee via OfficeKB.com	Excel Discussion (Misc queries)	3	March 25th 05 02:03 AM
using vlookup - how do I match 2 spreadsheets w/o same exact numb.	klondike47	Excel Worksheet Functions	1	February 5th 05 11:01 PM
Find a match that;s not exact	Phyllis	Excel Worksheet Functions	0	November 8th 04 08:12 PM
Vlookup, Index & Match	Phyllis	Excel Worksheet Functions	1	November 8th 04 06:11 PM

All times are GMT +1. The time now is 03:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us