help regarding indexing and matching

hello, i am new to this forum, though in a few days i have got a grasp of a few concepts, i am still new to excel in general.

My problem is that i need help in indexing and matching,
my sample workbook would show it clearly,
in short,
i have 2 columns in sheet 1, with A giving the product name and b giving its value
and in sheet 2, i have Columns A & Column B which is essentially when put together gives the value of corresponding cells in column A,

i want a function which would give me the proper values in sheet 2 from sheet 1
...

firstly i didnt quiet expect a fast response, thank you for your time, but

i already tried both and it dosent work, because i didnt mention one more criteria, that is, the 2nd workpage may have more than the required strings in the cells, so exact matches wont take place, when 0 is considered,
i have uploaded one more sample,
though i am working on a worksheet with around 1700 columns, the given basic code would be quiet helpful,
remember,the contents in worksheet b will have more strings than the required when compared to sheet a

than you once again, both formulas work perfectly in the sample i gave, but when i tried it on the main project, it failed,


heres the most general scenario, i hope you understand what i mean,

we are almost there

i know i am no coding expert, but as far as i understand, your formula just checks if the first cell contents matches with list in sheet1, but it dosent check the contents of column b where data could change
,

its one last hurdle, and its there

thanks

this is Exactly what i am looking for
the helper column is what was needed
thank you

Dear Praveen

u can use vlookup for that ,,,,, if can be halful for u.
please find attchment