Dear evert body

i have 2 work sheet
one woksheet having datas like
aaa 11 12 14 12
bbb 22 22 22 22
aaa 33 23 44 55
aaa 43 23 54 23
bbb 333 333 22 111

another second worksheet is having form
if i type second worksheet a1 cell aaa , i want all data from one worksheet

like result

aaa
11 12 14 12
33 23 44 55
43 23 54 23

Regards
Manoharan



--
manoharan


"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