Posted to microsoft.public.excel.worksheet.functions

Samuel

external usenet poster

Posts: 26

vlookup on multiple values

I have the following data in 3 columns

A B C
TOP BULB 1
TOP SCREW 5
TOP LIGHT 1
TOP LAMP 1
TOP PAPER 1
BOTTOM BULB 5
BOTTOM SCREW 4
BOTTOM LIGHT 2
BOTTOM LAMP 8
BOTTOM PAPER 7

I want to be able to first match against the value in column a then find the
match in column b once it finds both match then return the result of column
3.

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 multiple values	suraneniaditya	Excel Worksheet Functions	4	March 7th 08 03:58 AM
Vlookup for multiple values	SCHM	Excel Worksheet Functions	6	June 23rd 06 09:10 PM
How do I allow for multiple values in VLOOKUP?	Indy_Ball	Excel Worksheet Functions	3	May 1st 06 09:57 PM
vlookup, multiple values, sum values into one cell??	Phillips L	Excel Worksheet Functions	4	November 9th 05 12:31 AM
VLOOKUP FOR MULTIPLE VALUES	RITA	Setting up and Configuration of Excel	1	February 10th 05 11:42 PM

All times are GMT +1. The time now is 10:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us