INDEX/MATCH Help

[Buzz1126]

I need to grab values from column A every time a number occurs. So, In column A I have different WO#'s, there are no repeats. In column C I have different Auction Numbers (Several repeats).

Every time, say 39, appears in column C I need to grab the corresponding WO from column A.

Thanks in advance,

Matt

[rahi_feri]

could you send the file?

[Buzz1126]

Yeah the actual sheet is much more complicated though. All of this is for a college project by the way so I really do appreciate the help.

The data is under the Mannheim Car Data tab.
And I want to pull data from the Mannheim Car Data tab and place it in the Current Auction Database Tab.

So you hit run, type in 39 (the auction number), and it will begin to set up the Current Auction Database. The main thing I need to do is pull the WO from col. A of the Mannheim Car Data tab and place it in col D of the current Auction Database tab.

Matt

[Buzz1126]

the formula that is currently in col D of the CurrentAuctionDatabase tab does not work

[Tony Valko]

Try something like this...

Data Range

	A	B	C	D	E
1	WO#	Auction	------	Auction	WO#
2	WO1	28		39	WO2
3	WO2	39			WO4
4	WO3	20			WO5
5	WO4	39			WO10
6	WO5	39
7	WO6	25
8	WO7	17
9	WO8	12
10	WO9	30
11	WO10	39

This array formula** entered in E2:

=IFERROR(INDEX(A:A,SMALL(IF(B$2:B$11=D$2,ROW(B$2:B$11)),ROWS(E$2:E2))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.

[rahi_feri]

the auction number will be repetitive!Doesn't it important?
and which column is the auction number in sheet "Manheim Car Data"?
and also you have written the wrong address i mean wrong about absolute and relative in index function!

[rahi_feri]

i think i got it !
if in sheet "Manheim Car Data" you are searching for 39 and you expect to return different codes with this formula you are wrong!
the best way is to say a unique code(ID) in both table!