I can solve this in VBA easy enough but it's bugging me that I can't think of a formula combination to solve it natively in Excel.

I need to know if a value in column A is present anywhere in columns B to D. It could be in any row and in any column.

Index / match won't work as far as I know because both the row and the column are variable. Ideally I need something like Find or Search that takes a multi-dimensional array, not just one row, column or string.