taz23340
Active Member
- Joined
- Jun 11, 2003
- Messages
- 336
hig uys, it's the pain in the *** again. hehe.
i am once again trying to make my workbook more entertaining. mroe auto stuff so i can be lazy.
in my past posts i learned how to correct the #div/0 so that my vlookups would work. and when i use an if statement over and over it now works to give me the results of my teams score on another sheet.
what i want to do know is make vlookup do this.
in sheet1 i have cellsb32 and b33 with the name of each team. example boston and new york. and in cells n32 and n33 i have their final scores. so if the game is 7-6 for example i will do an if statment that if cell n32 is greater than n33 than 1 if not then 0. but how can i make v and h lookup do this for me?
i can do a vlookup for the score but i want the 1 or 0 answer.
thanks in advance for your help
i am once again trying to make my workbook more entertaining. mroe auto stuff so i can be lazy.
in my past posts i learned how to correct the #div/0 so that my vlookups would work. and when i use an if statement over and over it now works to give me the results of my teams score on another sheet.
what i want to do know is make vlookup do this.
in sheet1 i have cellsb32 and b33 with the name of each team. example boston and new york. and in cells n32 and n33 i have their final scores. so if the game is 7-6 for example i will do an if statment that if cell n32 is greater than n33 than 1 if not then 0. but how can i make v and h lookup do this for me?
i can do a vlookup for the score but i want the 1 or 0 answer.
thanks in advance for your help