find text from a certain row onwards from another sheet

[rainx]

Hi all,

I need some help over here. I have a list of numbers and dates in a sheet in different columns. I am trying search this list of numbers from 2 sheets from another file to see if the number had been registered there. I will also need to match the corresponding date in that sheet as the number might been registered in a previous date.

Subsequently, i am hoping it is able to return "yes" if it is able to find a match (registered) and "no" if not found. The return value should be reflected beside the column with the list of numbers.

Think it is rather complicated, hope someone out there could help!

Appreciate any help!

 

[pbornemeier]

Please restate your request using specific workbook names, sheet names and cell addresses (columns/rows).
Where is / What is the "certain row onwards" that you refer to in your title?