Need macro/formula for data table

[Pony0011]

I have a data table with 4 columns, 3 are text, 1 is a number. Need to know how to write formula on another spreadsheet that will search through data table and find number that matches exactly and post number on second spreadsheet. Have searched through the lookups but can not locate one that handle 3 parameters for the search. Any help would be greatly appreciated.


I am using excel 2007 and Windows XP - home

Thanks,
Pony0011