What do you use for identification for those parts with no part number?
is the description unique enough that it can be used?
if so and you have a table with the description value combo
try something like
=if(iserror(Vlookup[based on part number with false for 4th entry]),vlookup
[based on description with false for 4the entry],Vlookup[based on part
number])

"rajeev" wrote:

Hi,
I am working on a data in which Column A,B&C of sheet1 contains the
following:

PART NO. DESCRIPTION AMOUNT

In case of some of data there is no part No. only description.

In sheet2 i uses VLOOKUP to get the AMOUNT with LOOKUP values related
to part no. but i am facing problem in case of components that does not
have Part Nos.
How can i get the values in the same column for components with or
without part no.

Thanks in advance.

Regards
Rajeev