Posted to microsoft.public.excel.worksheet.functions

Lemmesee

external usenet poster

Posts: 31

Help with Formula IF INDEX AND MATCH

I have a Sheet of IMPORTED DATA(Sheet1). On another sheet, I need a formula
compare the data in Col's B AND C then return the related data from coumn A.
I hope the example below describes it.

Thanks in advance

Sheet1
A B C
1 PN1
2 20x12
3 CB100
4 PN2
5 20x12
6 CC100
7 PN3
8 15x18
9 CC100
10 PN4
11 20x30
12 CB100

Sheet2
A B C
1 20x30 CB100 PN4
2 20x12 CC100 PN2
3 20x12 CB100 PN1
4 15x18 CC100 PN3

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
Using Index and Match Formula	Brett[_2_]	Excel Worksheet Functions	2	June 5th 09 02:39 PM
Index and Match Formula	Barbara Schneier	Excel Worksheet Functions	4	January 7th 07 06:07 PM
Need Help w/ Index and Match Formula	japorms	Excel Worksheet Functions	1	July 10th 06 09:57 PM
INDEX and MATCH in one formula...	NWO	Excel Worksheet Functions	1	April 14th 06 11:25 PM
How do I display more than one match in a Index/Match formula?	Trish	Excel Worksheet Functions	0	September 26th 05 10:21 PM

All times are GMT +1. The time now is 11:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us