Posted to microsoft.public.excel.misc

Humphrey

external usenet poster

Posts: 22

VLOOKUP using 2 columns

I have a table of component information that has the first two columns headed
Make and Model. Is there any way to do a VLOOKUP on an unique combination of
two columns? This is a dynamic list so I don't want to create single
concatenated column of Make & " " & Model.
What would be my options were this function not available?

H

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
Vlookup on 2 columns	YeahWiwl123	Excel Discussion (Misc queries)	5	September 6th 07 02:44 PM
VLOOKUP for 2 columns or more	FC	Excel Discussion (Misc queries)	1	June 6th 07 02:20 AM
VLookup in to columns	Frederik	Excel Worksheet Functions	2	October 26th 06 08:48 PM
Vlookup from 2 columns	cursednomore	Excel Worksheet Functions	2	July 7th 06 05:57 PM
Vlookup using two columns	Daniel Bonallack	Excel Worksheet Functions	3	December 9th 05 07:02 PM

All times are GMT +1. The time now is 09:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us