match or vlookup functions?

[jolly79_ph]

Hi,

I have two columns, 1. List names and 2. Symbol quote. This are m
masterlist.
Now, I want it to match with other four columns which unorderly lis
thru symbol quote which is the second column, 1. list names, 2. symbo
quote, 3. close, 4. volume.

Can anyone can help me, what formula do i use

 

[Frank Kabel]

Hi
try something like
=VLOOKUP(A1,'unorderd_list_sheet'!$A$1:$D$1000,3,0)