See the VLOOKUP function:

in (for example) B2 of Sheet1

=VLOOKUP(A2,Sheet2!A:Z,2,0)

will return entry in column B (signified by the 2) in models match.

HTH




"Shariq" wrote:

I have 2 compare model in one worksheet 2 model in another and if it matches
then bring the corresponding value, would any formula work?If yes then please
share with example...

Example:
Model 1 in column A of work sheet x
Model 1 in coulmn A OF work sheet y
Result: Value z from sheey y in column B of sheet x