Think there's nothing wrong with your adaptation. Assuming there should be
a match/result for the inputs: BOOTS/LIL DIG, then probably the source data
may contain extraneous white spaces (leading, trailing or in-between spaces)
which is throwing the matching off (These spaces are not readily visible).

We could use TRIM around cols B and H to make the matching more robust:
=INDEX('Sales and GC'!$I$7:$I$65000,MATCH(1,(TRIM('Sales and
GC'!$B$7:$B$65000)="BOOTS")*(TRIM('Sales and GC'!$H$7:$H$65000)="LIL
DIG"),0))

(Above array-entered as before)

P/s: Try using the smallest range large enough to cover, for calc
efficiency/performance. Your range is pretty large <g.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"certain_death"
wrote in message
news:certain_death.237vfm_1139916301.0022@excelfor um-nospam.com...

Hi Max
Have tried this but am getting the classic #N/A response.
What am I doing wrong?
Here is my formula

=INDEX('Sales and GC'!$I$7:$I$65000,MATCH(1,('Sales and
GC'!$B$7:$B$65000="BOOTS")*('Sales and GC'!$H$7:$H$65000="LIL
DIG"),0))

Anything I'm doing wrong?

Thanks
Mark:)


--
certain_death
------------------------------------------------------------------------
certain_death's Profile:
http://www.excelforum.com/member.php...o&userid=24561
View this thread: http://www.excelforum.com/showthread...hreadid=512174