vlookup or something else

[neditheg]

Hy guys... this should be easy ...

so I've attached my excel file ...

I've made yellow some columns .... so in the second sheet I want to putvalues from sheet1 .. if ... there is a match between column L (sheet 1) and column M (shhet 2) ...

i've tried a combined If function .. but didn't work .. and now i'm thinking to use vlookup in someway :| ... thanks !!!

[neditheg]

=IF(ISERROR(MATCH(Sheet1!L3;Sheet2!$M$2:$M$4;FALSE));" ";Sheet1!C3)

i think this works .. sry for this post

[mohanvijay]

Hai Use index function and i attached solved one