Joining Formulae

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hi All
Can somebody please show me the correct syntax for the 2
formulae below so that they are 1 formula


Formula1

=IF(ISNA(VLOOKUP(B8,Stroke!D$5:$N$60,11,FALSE)),"0",VLOOKUP
(B8,Stroke!$D$5:$N$60,11,FALSE))

Formula2

=IF(ISNA(VLOOKUP(B8,STBLF!$D$5:$N$60,11,FALSE)),"0",VLOOKUP
(B8,STBLF!$D$5:$N$60,11,FALSE))

I've got this far but now need to do some cleaning up
Regards
Michael
 
Try this out.

If *both* lists have a match for B8, sheet "Stroke" has the precedence.

=IF(ISNA(MATCH(B8,Stroke!$D$5:$D$60,0)),IF(ISNA(MATCH(B8,STBLF!$D$5:$D$60,0)
),"0",VLOOKUP(B8,STBLF!$D$5:$N$60,11,0)),VLOOKUP(B8,Stroke!$D$5:$N$60,11,0))

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi All
Can somebody please show me the correct syntax for the 2
formulae below so that they are 1 formula


Formula1

=IF(ISNA(VLOOKUP(B8,Stroke!D$5:$N$60,11,FALSE)),"0",VLOOKUP
(B8,Stroke!$D$5:$N$60,11,FALSE))

Formula2

=IF(ISNA(VLOOKUP(B8,STBLF!$D$5:$N$60,11,FALSE)),"0",VLOOKUP
(B8,STBLF!$D$5:$N$60,11,FALSE))

I've got this far but now need to do some cleaning up
Regards
Michael
 
Back
Top