Using vba to index - match to a different worksheet

Hello,
The following code is something I've been trying to get to work for a couple of hours now.
I'm not that great at VBA scripting as I've just been teaching myself over the last couple of weeks.
Any help with this would be apreciated.

The problem is that the code I've made to extract the value for "BATCH / SERIAL" that corrosponds to the "PO" from another spreadsheet (which uses =indirect() forumlae so I have to open another spreadsheet too) doesn't work It just doesn't find the value even though it's in there.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Cheers.

Hutchay

also I'm also struggling with the following:

Please Login or Register  to view this content.

It's part of the same macro.. not sure why it doesn't work

To set "RESPONSE" as the row number in which "INPUT_VAR" is found in the column E:E of the spreadsheet "SERIAL V PO.XLS".