PDA

View Full Version : vlookup or something else



neditheg
08-20-2010, 06:42 AM
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
08-20-2010, 06:55 AM
=IF(ISERROR(MATCH(Sheet1!L3;Sheet2!$M$2:$M$4;FALSE));" ";Sheet1!C3)

i think this works :) .. sry for this post

mohanvijay
08-20-2010, 11:05 PM
Hai Use index function and i attached solved one