on sheet 1 i have the following columns

unit # description qty

and on sheet 2 i have the following columns

unit # pd fo cost

i want to get the pd, fo, and cost info on to sheet 1 by using the unit # as reference.

i have the following formula =LOOKUP(A30,sheet2!A$2:$A$672,NBV!$B$2:$B$672) in the next blank column on sheet 1.

this works except, when i have a unit # on sheet 1 (for example 5), but no unit # 5 on sheet 2 it goes to the nearest unit # to 5. I don't know how to make it be an exact match so it matches the unit #'s exactly on both sheets.

any help would be greatly appreciated.

thanks!

shelby