matching the data

[kshari8888]

i have data like this in one sheet

no tt sa

654 1415 1000

655 1416 2000

656 7415 3000

and data in sheet2 like this

tt bonus

1415 500

1416 600

1417 700

7415 800

7416 900

what i wnat is the formula to be used to have data like this

no tt sa tt bonus

654 1415 1000 1415 500

655 1416 2000 1416 600

and so on..

it should match values in both tables.

Please guide me.

 

[Faseeh]

Hi Kshari8888,


Welcome to the forums, You can use vlookup() for this purpose


654 1415 1000 1415 500

655 1416 2000 1416 600

656 7415 3000 7415 800


Your data in A2:B4, use:

[pre]

In D2, =B2
In E2, =VLOOKUP(B2,Sheet2!$A$2:$B$5,2)

[/pre]

If unclear please upload a sample sheet.


Regards,