Stop relation between two sheets

Originally Posted by Dipwind

Hi,

There is any way to stop, the relation between a sheet to other sheet?

I have a sheet "principal" where I have data that can be until 150 different names. In the same workbook I have more seven sheets representing the week days, all the seven sheets are related with "principal" but I only can use 8 "IF's". Normally on the third day I need to change the principal to fill automatically the week day's sheets.

In the end I generate a report, with wrong data, because when I change the "principal", the day one and day two, is also changed.

Can I say to a sheet "with a function or formula", to stop relate with principal, something like "complete and close"????

thanks in advance
João

Hi,

Probably can, would you like to post a sample few formula for a more detailed reply, especially the 'If' formuula?

---

Originally Posted by Dipwind

Sorry my late reply,

I'm using this formula:

=IF(A8=PR!$B$3,PR!$D$3,IF(A8=PR!$B$4,PR!$D$4,IF(A8=PR!$B$5,PR!$D$5,IF(A8=PR!$B$6,PR!$D$6,IF(A8=PR!$B$7,PR!$D$7,IF(A8=PR!$B$8,PR!$D$8,IF(A8=PR!$B$9,PR!$D$9,IF(A8=PR!$B$10,PR!$D$10,0))))))))

In the seven sheets from the week, I only need to put a number and part of the information comes from "Principal" but if I need to add more people on principal, I can't put more ifs in the same cell.

thanks in advance
joão

HJi,

Try

=IF(ISERROR(VLOOKUP(A8,pr!$B$3:pr!$D$10,3,FALSE)),0,VLOOKUP(A8,pr!$B$3:pr!$D$10,3,FALSE))


You can then extend the range.
---

Originally Posted by Dipwind

That's great, works in a perfection.

many thanks Bryan
João

Good to see, and thanks for the response.

---