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
Bookmarks