Hallo everybody

I will try to do this as short and brief as possible.

In sheet1 cell D26 I wanna have a statement that shows whether the values from list A (a data sheet only containing some ID's) can be found in list B or not (a sheet of "masterdata" containing all ID's)

In short:

I have some ID's in Sheet 2 column F and I have some ID's in sheet3 column A. What I wanna have is an equation in Sheet1 Cell D26 where I test whether or not the ID's in sheet2 column F is part of the masterdatafile containing the ID's (sheet3 column A). I wanna use a formula that returns some kind of statement/text string telling me, whether my IDs in sheet2 can actually be found in my masterdata Sheet3.

I hope you have the information needed in order du help me out. Otherwise dont hesitate to write!

Kind regards