We have a worksheet that contains a column of unique Identification
numbers and several different types of tests. The following example
shows the layout:

A B C D E F
G
1 LabID Test1 Test2 Test3 Test4 Test5 Test6
2 5123 Cd As Ag Cu Hg Zn
3 5124 Cr B Ba As Cd Ni
4 5125 Ni Pb Cu Cr Ag Be
5 5126 Pb Ag B Ba Be Cu

How would I find the cell that contains Ag for LabID 525?


Something like Find LabID = 5125 then look ONLY in that row to see if
one of the cells in that specific row contains the text Ag.

I do not want to find Ag in any row but the row that has the labid
5125. In this case - Ag is on the same row as the labid.

The problem is: if Ag is not on that the same row as the specified
LabId I do not need to find Ag on a following row. If Ag were not on
the row of LabID 5125 I would need to have
foundcell = nothing as the result.

2nd possibility:
Look at LabID 5124 - the row does not contain Ag. I need to be able to
say:
find 5124 then look in this row to see if one of the cells in this row
contains the text Ag. The result I need is foundcell is nothing.


I have tried using find twice in a row. First find the LabId then Find
the test. The problem is that if the particular test I am looking for
is not on the same row as the LabID in the first Find statement, the
test does appear several rows later. The test must be required on the
specific LabID.


Any help would be appreciated



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/