hello, i am having a problem with a lookup formula. here is what i have so far.
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
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