Sorry – we don't have a ton of people here who do Excel programming. In general, most of us try to avoid it like the plague because it's so complicated and time-consuming. Give me a SQL Server database any day!
The excel spread is created by HR. I figure it out though. This is this a snippet. Also Get-filename is a function that open a windows so I can select the file. $excelsearchRange is how I was able to search for a value of a merge cell.