Thanks - between your reply and BJ's I now have my resolution - is there any
way i can use Conditional Formatting to hide the 'not applicable' responses?
--
Thanks and have a good day

Ruth


"Pete_UK" wrote:

You will need to supply a bit more information if you want a specific
solution, but by concatenating A and B together (in a newly inserted
column C on the sheet you have) then you could make use of VLOOKUP. It
might be better to set this up on a new sheet, where A2 and B2 contain
the sets of criteria you are interested in, then if your original
sheet is called Sheet1 you would have something like this in C2 of the
new sheet:

=VLOOKUP($A2&$B2,Sheet1!$C$2:$Y$1000,COLUMN()-1,0)

The formula can be copied across to X2 to return the data which
matches. You can also put other criteria in A3/B3 etc down these
columns, and copy the formula down.

Hope this helps.

Pete

On Apr 27, 11:30 am, RWilliams
wrote:
I have a large amount of data out of Project and i want to search for a row
that satisfies 2 specified criteria from column A and B and copy and paste
the information for that row (columns A to X) into a particular position on
another sheet ... I need to do this for approximatley 100 sets of criteria so
do not want to do it manually if i can help it .... I am not even sure where
to start with this ... if anyone has any thoughts I would be happy to try
....???
--
Thanks and have a good day

Ruth