Quote:
Originally Posted by thelauncher
Hi all,
I'm having trouble trying to figure out a formula using IF and Vlookup. Basically what I need is to lookup a value from sheet1 that should be somewhere in sheet2. Once vlookup has located this value it then needs to go a certain amount of columns accross eg 10 in sheet2 to find another value (as a normal vlookup does). Now I cant figure it out: IF the value in sheet2 in this cell matches a value in sheet1 then I need the formula to return a 1, if it does not match then I need it to return a 0. I cant quite figure out how the formula would go, with nested functions etc
If anyone could assist that would be great as its driving me mad 
launcher |
have you tried a countif formula. It will look if something exists on sheet 2 from what is on sheet 1. =countif('sheet2'!A:A,'sheet1'!a1)
This will count how many times that record exists. as far as nesting formulas it is easy to get comfortable with this by watching the tooltips.
For example when writing an if statement you start with =if(
now the tool tips will tell you that you are writing the condition. then you press a comma and it asks for what you want if the condition is true. You can put another formula in here if you want. try a sum write =if(a1=9,sum(6+3),sum(6-3))
Notice the last parentheses to close off the original if formula. It is very good to get comfortable with nesting functions. give it a shot and let us know what you come up with.