Posts: n/a

vlookup from multiple columns

I would like to look up a value in columnns b,d,f etc and return the
corresponiding value in the adjacent column c,e,g

B C D E F G
2 30000 A 30150 b 30300 c
3 30200 a1 30351 b2 30502 b3

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
how do I use vlookup for multiple occurrences of the same value	bj	Excel Worksheet Functions	0	April 27th 05 10:43 PM
vlookup for multiple columns	[email protected]	Excel Worksheet Functions	0	April 22nd 05 07:28 PM
vlookup for multiple columns	MXC	Excel Worksheet Functions	6	March 4th 05 09:59 PM
Convert multiple columns to rows	Lois Lane	Excel Worksheet Functions	8	January 10th 05 12:47 AM
Multiple Vlookup?	changeable	Excel Worksheet Functions	0	November 9th 04 11:52 AM

All times are GMT +1. The time now is 07:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us