Excel Code Query

Cotta

Morning All,

I'm looking at a spreadsheet that someone else used to look after and I was wondering what the "T2 code" aspect relates to, can anyone help?

=VLOOKUP($CD21,'Test Folder\Test Folder_2\[File_1_EA_v3_Today.xls]T2 code'!$A$1:$G$65536,4,FALSE)

Thanks

Mister_aaa

It's the sheet name in File_1_EA_v3_Today.xls

Basically, it is looking up whatever is in cell cd21, from columns A:G in sheet T2 Code in worksheet ''Test Folder\Test Folder_2\[File_1_EA_v3_Today.xls' and returning whatever is in column D.

Agrajag

What he said ^ ^

Note that references to other files can be temperamental. It may be best to OPEN
File_1_EA_v3_Today.xls from the Test Folder\Test Folder_2\ directory, then go back to your original spreadsheet and press F9. This will refresh the lookup.

If you do not HAVE this other file, then EXCEL will either give you a #NA, or leave the cell at whatever value it had when it could last find that other file.