Vlookup Problem
Hi Biff,
I've seen you do this a couple of times lately - ie use an IF function
without an operator in the criteria. In this case, when the COUNTIF returns
1, the first option is chosen; when it returns 0, the second option is
chosen. Does the IF function just recognize a zero as FALSE, and anything
else as TRUE?.
Regards - Dave.
"T. Valko" wrote:
Another one:
=IF(COUNTIF('Week 2 Dataset'!G:G,D81),VLOOKUP(D81,'Week 2
Dataset'!G:O,9,0),"")
|