Hi thank for your response. What do you mean create list in the column of master list?

the name of the sheet?

What Im trying to do is for example in Sheet A Column E should be equal in Master List column B if Master List Column F is equal to Sheet A Column B.

I try this formula but its not working in other sheets:

=IF(a!B3='Master List'!F3,'Master List'!B3,"")