May 02 2019 09:00 PM
HI
i have one more question. i added new column and give a condition by IF formula to get complete items and non complete items. and also i have added new sheet and copy closing stock details for it. i need to make a hyperlink when click on condition column cell to filter relevant data from sheet 2
May 03 2019 01:02 AM
In Sheet1!F4 of the attached file, the formula, copied down rows, is:
=IF(COUNTIF(Sheet2!A:A,C4),HYPERLINK("#Sheet2!D"&
MATCH(C4,Sheet2!A:A,0),
IF(D4=E4,"Complete","Incomplete")),"None")
Note that the foregoing formula returns:
"None" if the item is not found in Sheet2;
Hyperlink named "Complete", if the stock is sufficient; or
Hyperlink named "Incomplete", if the stock is insufficient.
I hope this fulfills your requirement.