brendanolear
Active Member
- Joined
- Apr 26, 2008
- Messages
- 366
Have created formula as below:
=if(F5=Sheet1!$A$2:$A$200,vlookup(G5,Sheet3!$B$4:$C$50,2,false),0)
not returning anything though there is data there that meets criteria.
What am I missing?
=if(F5=Sheet1!$A$2:$A$200,vlookup(G5,Sheet3!$B$4:$C$50,2,false),0)
not returning anything though there is data there that meets criteria.
What am I missing?