And() if() vlookup() combination

[meyero90]

Hello,

I’m trying to find a formula that will attempt to do the following with respect to a Weight (%) and Fund Name:
If() Weight (column B) is >0, then Vlookup () the corresponding, and return “INVESTED”, IF NOT (meaning Weight =0), return “NOT INVESTED”.

Thank you All Again for you help

Don’t hesitate to come up another way to do it. I started to do AND(IF(X>0 vlookup(XX,XX,X,0),”invested”,if(X=0 vlookup(XX,XX,X,0),”not invested” …… and then I got stuck because I want the weight to match the name (vlookup does it), but couldn’t find the argument that will help add “invested”, “not invested”.

Attached is the sample

[contaminated]

=IF(B4>0,C4,"NOT INVESTED")

Is this what you want?

[meyero90]

Nope, it's really not that. Thanks though

[Palmetto]

Perhaps this: =IF(B4>0,IF(VLOOKUP(B4,$B$4:$C$20,2,FALSE)="","Not Funded","Funded"),"")

[meyero90]

It works, but when the weight is equal to 0, I should get "Not Invested", but instead I get "" (nothing).
Thanks

[day92]

Try this..

=IF(B4>0,IF(VLOOKUP(B4,$B$4:$C$20,2,0)="","","Funded"),"Not Funded")

[meyero90]

Sweet, it works!!!! Thanks day92