I want to combine the following into one statement,
=IF(ISNA(VLOOKUP($A2,'WTD'!$A$2:$F$5,5,FALSE)),H2,ROUND(H2*0.25,2))
And
=IF(ISNA(VLOOKUP($A2,'WTR'!$A$2:$F$10,5,FALSE)),H2,ROUND(H2*0.1,2))
Basically, do both of those functions, since there drawing from 2 different sheets.
How to combine?
Thanks
Bookmarks