#N/A is exactly what i want to avoid .... your suggestion is great but does
not seem to work with my formula =VLOOKUP($A$38&$B$38,$C$26:$G$34,2,FALSE)

Should your version look like:
=IF(IsNA(VLOOKUP($A$38&$B$38,$C$26:$G$34,2,FALSE), "",(VLOOKUP($A$38&$B$38,$C$26:$G$34,2,FALSE))
because this returns the standard Error message and highlights the "" as the
first error

Any thoughts on what i am doing wrong?
--
Thanks and have a good day

Ruth


"Pete_UK" wrote:

Do you mean that you get #N/A errors showing up where there is no
match? If so, then you can trap this by modifying the formula along
the lines:

=IF(ISNA(VLOOKUP( ... ),"",VLOOKUP( ... ))

Basically, this means if there is an error then return "" (blank
cell), otherwise do the Vlookup. You could make "" into something more
meaningful if you wish, like "not present".

Hope this helps.

Pete

On Apr 30, 3:16 pm, RWilliams
wrote:
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- Hide quoted text -

- Show quoted text -