• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

conditional vlookup

sudipto3003

sudipto3003

Member
Dear Friends,
I have a file link below. Where in sheet "formula" i need a formula in col "c". Required Doc no from "master" sheet against the "item code". now the logic is in "master" sheet against the items i have the "stock in" date and in "formula" sheet i have the "stock out" date. now if the difference between "stock in" & "stock out" is <=90 days then it will give the "doc no" from master sheet. there may be in "master" sheet a same item code more than one times in a same "stock in" date. in that case if possible get all the "doc no"s. Frankly i am confused, need your suggestions friends.

https://www.dropbox.com/s/fgsajq6440ra4xi/example.xlsx?dl=0
 
Hi,

Can you try below formula.

=IF(VLOOKUP(B4,master!$A$3:$C$3052,2,0)-A4<=90,VLOOKUP(B4,master!$A$3:$C$3052,3,0),"")

in C4 and copy down.

Regards,
 
Thank you Somendra,
I have tried this formula before here, but as I have mentioned earlier in "master" file there are some item codes in same date with different "doc no". If the date consider <=90 days then required all the doc nos.
 
Yes, I have found the solution. I have used the following formula:
=iferror(if(vlookup($b4,master!$b$3:$c$3052,2,0)-formula!$a4<=90,vlookup($b4&columns($c$3:c$3),tablData,4,false),">90"),"Not Found")
Thank you Somendra and Chandoo.
 
You must log in or register to reply here.
Back
Top