D_Rennie
08-14-2009, 07:45 PM
Hello gurus.
I have a question that requires a lookup function.
There is column E. with the forumular from E6 Down =IF(C6="","",IF(C6<=SUMIF(Sheet1!A:A,A6,Sheet1!D:D),"Yes","No"))
This does the lookup to see it im trying to take out more items that i have in stock. If im trying to take out more that i have No is placed into the Cell.
The problem that im having using this is. I want to keep the yes or no value that is placed into that cell even after the amounts are changed in "sheet1" so that prity much says that i cant use the formular and have to use VBa.
Also have a condtional format that will highlight a row if cell E6 is no and date is between now and 10 days ago.
=AND($E6="No",TODAY()<$D6+10)
This just shows that that item needs to go on a backorder asap.
The reason that i want to keep the original yes or no and that cell to not change after updating data on "sheet1" is i can tell how many times a item had to go in backorder in a timeperiodl.
I can upload a example workbook. There is alot of other interaction with these two sheets that may or maynot be problematic, so if you are intrested in looking at the original workbook shoot me a pm and i will email it.
If what i havce wrote doesnt make sence. let me know and ill try to explain again.
Thankyou.
I have a question that requires a lookup function.
There is column E. with the forumular from E6 Down =IF(C6="","",IF(C6<=SUMIF(Sheet1!A:A,A6,Sheet1!D:D),"Yes","No"))
This does the lookup to see it im trying to take out more items that i have in stock. If im trying to take out more that i have No is placed into the Cell.
The problem that im having using this is. I want to keep the yes or no value that is placed into that cell even after the amounts are changed in "sheet1" so that prity much says that i cant use the formular and have to use VBa.
Also have a condtional format that will highlight a row if cell E6 is no and date is between now and 10 days ago.
=AND($E6="No",TODAY()<$D6+10)
This just shows that that item needs to go on a backorder asap.
The reason that i want to keep the original yes or no and that cell to not change after updating data on "sheet1" is i can tell how many times a item had to go in backorder in a timeperiodl.
I can upload a example workbook. There is alot of other interaction with these two sheets that may or maynot be problematic, so if you are intrested in looking at the original workbook shoot me a pm and i will email it.
If what i havce wrote doesnt make sence. let me know and ill try to explain again.
Thankyou.