One way ..

In Sheet1,
In T2, normal ENTER:
=INDEX(Sheet2!$J$2:J100,MATCH(TRUE,INDEX(D2&G2&H2= Sheet2!$I$2:$I$100,),0))
Copy down

And if you need an error trap, use ISNA on the MATCH bit of it, indicatively
like this:
=IF(ISNA(MATCH(..)),"",INDEX(..))

aloha? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Belinda7237" wrote:
I have a work sheet (worksheet 1) that has three columns of data and I want
to match it against another worksheet (worksheet 2) that has those same three
values in one column - if there is a match then i want to return a value in
column J of worksheet 2.

Worksheet 1:

Column D = 00001
Column G = 00000123456
Column H= 000123

Column T = Want value from worksheet 2 column J if all three above match

Worksheet 2:

Column I = 0000100000123456000123
Column J = 98765