Posted to microsoft.public.excel.misc

external usenet poster

Posts: 542

Vlookup off multiple columns

Hello there

I am trying to do a vlookup off multiple columns. For example below if I am
trying to find the result of "22" for a value "ZZ" in columns A to C below
how to I tell it to lookup in all 3 columns i.e. A-C and return the result in
column D?

A B C D
ZX ZZ ZA 22

--
James.

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 from multiple columns	James	Excel Discussion (Misc queries)	0	July 22nd 09 01:08 PM
Vlookup in multiple columns	Iriemon	Excel Worksheet Functions	2	May 6th 09 04:08 PM
Multiple columns using Vlookup	Hardeep kanwar	Excel Discussion (Misc queries)	3	March 6th 09 04:05 AM
Multiple Columns & VLookup??	Tara C.	Excel Worksheet Functions	1	October 12th 05 05:33 PM
vlookup for multiple columns	[email protected]	Excel Worksheet Functions	0	April 22nd 05 07:28 PM

All times are GMT +1. The time now is 01:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us