"noninacio" wrote:
does anyone can help me in this issues?
I just read the MS Training but i didn't get it.
Will be better if you can help me with examples and more simple explanations

Try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:
http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---