In Workbook 1 I'm using the formula;

=IF(ISNA(VLOOKUP(C2,INDIRECT("'C:\Documents and Settings\user\Desktop\["&A1&".xls]Sheet1'!$a1:b$300"),2,0)),"Not Applicable",(VLOOKUP(C2,INDIRECT("'C:\Documents and Settings\user\Desktop\["&A1&".xls]Sheet1'!$A1:B$300"),2,0)))

to grab data from Workbook 2.

My question is, rather than having to specify the lookup_value in cell C2, can I specify the value directly in the formula itself.

Example: if I want to return the value from Workbook 2 when "Example" is entered in cell C2. Instead of having to enter "Example" in C2 could the formula somehow have the word "Example" in it for the lookup_value.

Thanks for the help.