Small Table:
Name Description
P3586PR Pump 3586 Pressure
TCV3586EU Temp Control Valve 3586 Engineering Units
P3587PR Pump 3586 Pressure

Main Table:
Name Description Misc Data
Columns....
P3586HS Pump 3586 Handshake
P3586PR Pump 3586 Pressure
P3586Alm_Ack Pump 3586 Alarm Acknowledge
TCV3586EU Temp Control Valve 3586 Engineering Units
TCV3586SP Temp Control Valve 3586 Setpoint
P3587PR Pump 3586 Pressure

What I want to do is be able to use the small table as the criteria for a
search of the main table. If I can search by 'Name' (unique field on both)
and either just highlight the desired row or add a column to the main table
to specify which are (1=yes, 0=no), or create a new worksheet with the data,
whatever it takes.

Thanks again in advance.
"Dav" wrote:


It is still not clear what you require

In the small sheet you are trying to make a match with the master
sheet

Firstly are all the rows unique in the master sheet eg each name only
appears once and you wish to return this information to the small
sheet

or do you wish to return all the rows matching the row in the small
sheet?

Give a small example say 3lines in the small sheet and 10 lines in the
Master sheet (you do not need to list all the columns!) and describe
what you wish to happen

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=563462