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