hyperlink with filter

[Ravindu94]

HI

@Twifoo 

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

[#2]

@Ravindu94 

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. 

[#3]

@Twifoo 

thank you man. its nice

[#4]

You're welcome.