Posted to microsoft.public.excel.misc

external usenet poster

Posts: 542

Vlookup from 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
Linear Mode Switch to Hybrid Mode Switch to 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 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
VLOOKUP on multiple columns	David Ingham	Excel Discussion (Misc queries)	1	July 4th 08 01:55 AM
vlookup for multiple columns	JR	Excel Worksheet Functions	1	February 6th 06 03:51 PM
vlookup for multiple columns	MXC	Excel Worksheet Functions	6	March 4th 05 09:59 PM

All times are GMT +1. The time now is 09:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us