Cell value based on multiple cell data

[vromero2018]

Hi ALl

I am trying to came up with some formula or code to solve an issue that I have while working with some data for sales orders where I may or may not have inventory

order test.JPG


On Column F, I need a value based on column A and Column E, for example from rows A15 to A19, based also on the values of E15 to E19, this order is complete and I can print it, SO I expected have a value on column F that tells me this order is good to print, any ideas??

Thanks,

(I don't know if picture uploaded right)

[TMS]

Try:

Please Login or Register  to view this content.

copied down. Filter on "Complete".

[vromero2018]

Thank you TMS,

It works, the only thing is that I see you used the value of the Inventory available, I have checked on the case that even if we have inventory it may not be enough to fulfill the order, with this formula that you gave me I still get it as complete, what should I adjust??

See rows 12 and 14 for example where my inventory is less that what I need, in that case the order will not be marked.

Thanks again


test2.JPG

[TMS]

Ok, check column E for "Short Line"

[vromero2018]

Trying to, but that where I am stuck, sorry to bother,

I did this but I think I messed it up, I was trying to compare the value from Inventory to qty asked

=IF(COUNTIFS($A:$A, $A9,$D:$D,0)<$C:$C, "Complete","")

Thanks,

[TMS]

Try:

Please Login or Register  to view this content.

[vromero2018]

Worked.

Thank you man.

Thanks,

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.