Formula required please

[redspanna]

Hi all,
Can anybody suggest a formula that will carry out the following ...

IF cell A2 on SHEET2 is the same as cell A13 on sheet 'TEST' then VLOOKUP cell B17 in sheet 'TEST' through range C2:E15 of SHEET2 and copy 2nd colum along if true.

I can get the VLOOKUP part, ie

=VLOOKUP(B17,TEST!C2:E15,2,TRUE

but have no idea how to link this to the first part of my question

any help please

regards

 

[VoG]

Try

=IF(Sheet2!A2=Test!A13,VLOOKUP(B17,TEST!C2:E15,2,TRUE),"")

 

[Chris Mack]

=IF(SHEET2!A2=TEST!A13,VLOOKUP(TEST!B17,SHEET2!C2:E15,3,FALSE))

Is that it?

Chris

 

[Special-K99]

Your VLOOKUP does not reflect your description of the problem.
Try

=IF(Sheet2!A2=Test!A13,VLOOKUP(Test!B17,Sheet2!C2:E15,2,0),"")

NOTE: Chris and my solution differs from Vog's in the VLOOKUP.

 

[redspanna]

Thanks Guys - got it to work with your help