Hi Jini

You Could use the VLOOKUP Function for this

Something Like

=VLOOKUP($A1,Master!$A$1:$C$10,2,FALSE)

Where $A1 is the Value you Want to Match
Master!$A$1:$C$10 is the Table where your data is held
2 to tell which Column to Show
And FALSE to Search for Text Exactly

Just Change the Values to what you need

HTH
Davi

--
Message posted from http://www.ExcelForum.com