IF formula only showing positive results
I want to look up a column on another worksheet to look for a code and then
copy information from that row into the new worksheet. I am using a IF formula at present but I want the correct answers at the top of each page. Eg code =2 on sheet2 code =3 on sheet 3 but want the aanswers at the top of page instead of having blank rows. Hope you can understand what I'm asking |
IF formula only showing positive results
Your post is very difficult to understand. You can help by:
1. Post the If statement you are using. 2. Tell us what results it gives you. 3. Tell us what results you want to see instead. Regards, Fred. "Davidm" wrote in message ... I want to look up a column on another worksheet to look for a code and then copy information from that row into the new worksheet. I am using a IF formula at present but I want the correct answers at the top of each page. Eg code =2 on sheet2 code =3 on sheet 3 but want the aanswers at the top of page instead of having blank rows. Hope you can understand what I'm asking |
IF formula only showing positive results
This is the formula I am using at present =IF(Sheet1$A2=1,Sheet1B2,"") this is
giving me the right answer if A2 =1 but if I copy this down to the next few rows and B2=2 then the anwer will be "" which leaves blank rows until the next 1 is found in Column A of sheet 1 then it puts the correct answer in. I was wondering if I could change my formula so that the rows are elimated that have "" in them or do I have to sort Sheet 2 to bring the positive answers to the top of the page "Fred Smith" wrote: Your post is very difficult to understand. You can help by: 1. Post the If statement you are using. 2. Tell us what results it gives you. 3. Tell us what results you want to see instead. Regards, Fred. "Davidm" wrote in message ... I want to look up a column on another worksheet to look for a code and then copy information from that row into the new worksheet. I am using a IF formula at present but I want the correct answers at the top of each page. Eg code =2 on sheet2 code =3 on sheet 3 but want the aanswers at the top of page instead of having blank rows. Hope you can understand what I'm asking |
All times are GMT +1. The time now is 11:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com