Excel 2007 : IF function in correct way

[ALEZI]

Hello

Could somebody tell me what is wrong with my formula, first am I write correct formula, in example when I put formula I got result like fault condition(nije prona), formula looks :

=IF(EXACT(A4,Sheet2!A1:A50),LOOKUP(A4,Sheet2!A1:A48,Sheet2!B1:B49),"NIJE PRONA")

As you can see in example, I want to if found in two sheets same combination of numbers and letters (M10990A) take numbers in next right cell where combination was (56).

Example attached and thanks in advance

[arthurbr]

Are you looking for something like =VLOOKUP(Sheet1!A2,Sheet2!$A$2:$B$4,2) ?

[ALEZI]

Thanks arthurbr for answer,but it doesn't work in my case (i attached attempt with your suggestion),in my i have to find way to compare values in both sheets (column A) and if be founded same values than transfer number in column B sheet 2 to column B sheet 1 and some of values could reiterate sometimes (in one table exist two or more equals values,as i showed in example).Tables are not proportional,first table is bigger then second.

In my opinion we have to find way to recognize identical values into both table.

Thanks for your effort.

[arthurbr]

ooops, try =VLOOKUP(Sheet1!A2,Sheet2!$A$2:$B$4,2,false)

[ALEZI]

Yes, It is works, but one thing make me a problem, when function false (in sheet 2 did not exist right combination) than in my cells would be show “N/A”, this make me problem because I cannot calculate, will be helped if function going to false than showing like “0”.

Thanks for help.

[arthurbr]

This is a possibility
=if (countif(Sheet2!$A$2:$A$4,sheet1!a2),VLOOKUP(Sheet1!A2,Sheet2!$A$2:$B$4,2,false),0)

adapt ranges to fit

[ALEZI]

Yes,it is works,thanks a lot..