I want to index reference numbers from column B based on Columns C,D,E,
and I

Column B has the reference number
Column C is the Freezer Name
Column D is the location (i.e. Shelf number)
Column E is the Column in the freezer
Column I is any Transfer/Used/(any text)

I'm checking these columns from a worksheet called ClinPath. The
worksheet that calls those columns is called 'Freezer Diagrams'.

'Freezer Diagrams' worksheet is just a table that is set up to look
like the freezers that the reference numbers are stored in. I just want
to show where each reference number is stored for quick accessing.

here's what I have:

{=INDEX(ClinPath!$B$2:$B$5000,(ClinPath!$I$2:$I$50 00=$A$1)*(ClinPath!$C$2:$C$5000=K$2)*(ClinPath!$D$ 2:$D$5000=K$3)*(ClinPath!$E$2:$E$5000=K$4))}

$A$1 is just a blank cell
K$2 is the Freezer Name
K$3 is the Shelf Number
K$4 is the Column Number (in the freezer)

The formula is not referencing anything except the VERY first cell in
the reference that does not match the criteria at all.


--
malik641
------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=384870