IF and SEARCH COMMAND

N

Ntisch

Hi - I have two worksheets.

One worksheet, named data, contains information that I have inputted
The second worksheet, named summary, is intended to search the dat
worksheet and return a value if certain criteria are met.

The problem I am having is that, on the summary worksheet, I can't ge
the IF command correct. It runs (incorrectly);

=IF('Data '!C5:C27="A",'Data '!D5:D20, 0)

What I want the command to do is search the data range and if it find
an A, return the value in the next cell (immediately to the right o
the A cell).

Can anyone help?

thank
 
N

Ntisch

Thanks Frank that worked great.

The last part of this that I would like to accomplish is to have
separate VLookup to return the value in the cell two cells immediatel
to the right of
the "A" cell.

I have tried to play around with the numbers in the Vlookup formula t
get the desired result but to no avail.

Thank
 
Top