Essentially I just need to have lookup functionality. I need to go row by row and then access values from other rows in my excel document. How can this be accomplished?
You will probably have to use two tFileInputExcel components, and use one as a lookup in a tMap, using Left Join/Inner Join between columns to get your corresponding values.