Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Gradient toolbar
The Gradient toolbar in Photoshop illustrator how can i change the fill colour at the moment its on black and white i want to fill that in 3 colours something like white green and blend of yellow. can you help me plz- shah25
- Thread
- Replies: 1
- Forum: Adobe: Illustrator
-
VLOOKUPs with nested IF statement
=IF(OR(C63={"Tobacco","Cri","Peanuts"}),VLOOKUP(C63,tblFoodType,2,VLOOKUP(C63,tblProductTypeCode,3,0))) Thanks for your response - I have tried to correct the statement so it contains the correct number of arguments but non of the VLOOKUPS work even though the...- shah25
- Post #3
- Forum: Microsoft: Office
-
VLOOKUPs with nested IF statement
=IF(OR(C62={"Tobacco","Cri","Peanuts"}),VLOOKUP(C62,tblFoodType),VLOOKUP(C62,tblProductTypeCode,3,0)) I am trying to insert 1 VLOOKUP if Condition 1 is true and another VLOOKUP if condition 2 is true - but the result If Tobacco, Cri,Peanuts is true prints out...- shah25
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
Inserting a VLOOKUP Formula as Nested If into a Cell
Hello, I am having problems with using a formula =IF(C30 ="Tobacco","NotApplicable",IF(C30="Cri","Not Applicable",IF(C30="Peanuts","Not Applicable",'=VLOOKUP(C30,tblProductTypeCode,3)))) Which checks the products and if not Tobacco...- shah25
- Thread
- Replies: 4
- Forum: Microsoft: Office
