excel Vlookup formula

[anjali5]

Hi All,
I am very new to excel, someone emailed me the excel spreadsheet and in one of the cell there is a formula
=VLOOKUP($C2,'D:\Documents and Settings\test\Desktop\Weekly\092011\[2011_09_21.xlsx]WORKING'!$A$2:$D$262,4,0)

although, I looked up at the vlookup tutorial, I am unable to figure out the formula.

I was wondering if someone can explain me this formula.

I know the person who emaile me the spreadsheet is trying to populate one field based on another excel spreadhseet.

any help will be apprecaited.

[jeffreybrown]

C2 holds the lookup value which is being looked up in the table WORKING'!$A$2:$D$262 and returning what is in the 4 column

http://www.contextures.com/xlfunctions02.html

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)