if sheet 2 is your table
column A is the value to look for
column B is what you want to find

in sheet1
A1 is where you will enter your criteria
B1 you can enter this formula
=IF(ISNA(VLOOKUP(A1,Sheet2!A1:B250,2,FALSE)),"",VL OOKUP(A1,Sheet2!A1:B250,2,FALSE))

you don't have to use these ranges this is just an example of how to do
it


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=538387