Hi,

Please find below are the two tables, one is the master table and other
is the entry table. The master table contains
size(1,2,etc),spec(A!,A2,etc),material code(E90,E45,etc) and
description. The entry table contains size,spec,material code. What I
want to do is, with the size,spec and material code in the entry table
has to check the corresponding size,spec and material code in the
master table and retrieve the description aginst these matching
column.

Could anybody help me how to go on this

MASTER TABLE

DESCRIPTION
SPECMATERIALCODESIZE
ELBOW,90LR,WRT,BW,XS,ASTM A234 GR.WPB,ASME B16.9 A1 E90 2
ELBOW,45LR,WRT,BW,XS,ASTM A234 GR.WPB,ASME B16.9 A1 E45 2
ELBOW,90LR,WRT,SW,3000#,ASTM A105,ASME B16.11 A1 E90 1
ELBOW,45LR,FRGD,SW,3000#,ASTM A105,ASME B16.11 A1 E45 1
ELBOW,90LR,WRT,BW,STD,ASTM A234 GR.WPB,ASME B16.9 A2 E90 2
ELBOW,45LR,WRT,BW,STD,ASTM A234 GR.WPB,ASME B16.9 A2 E45 2


ENTRY TABLE

SPEC MATERIAL CODE SIZE
A1 E90 2
A1 E45 2

Regards,

Shiva


--
Shiva
------------------------------------------------------------------------
Shiva's Profile: http://www.excelforum.com/member.php...o&userid=28449
View this thread: http://www.excelforum.com/showthread...hreadid=480504