IF and SEARCH COMMAND

[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 '!D520, 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

 

[Frank Kabel]

Hi
use
=VLOOKUP("A",''Data '!C520,2,0)

 

[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

 

[Andy B]

Hi

Try:
=VLOOKUP("A",'Data '!C5:E20,3,0)

 

[Ntisch]

Thanks Andy - works just fin