Look up problem

  • Thread starter Thread starter john smith
  • Start date Start date
J

john smith

Hi,

I have a worksheet in a workbook that has two columns one for Part # and one
for Part Description

In another worksheet in the same workbook I have columns Part #,
Description, Qty, Price and Total

I used the lookup wizard to create a formula to return the Description for
an entered Part #.

This all works fine.

My problem is that if I have a non stocking item that is not in the Parts
List I want to be able to enter my own description in the description field
but I do not want to over write the look up formula that is in that field.

The reason I do not want to over write the formula is so when I go down to
the next line I can still use ctrl D to copy the formula down.

I know I could copy the formula down several lines ahead of time but I don't
want to do that.

Thanks in advance for any help offered

Dan
 
Maybe something along these lines would be workable ?

Assuming the Part#s are listed in col A,
present lookup formulae is in col B,
data in row2 downwards

Try 2 additional cols, C & D

In col C will be where you input the decriptions for Non-
stocking items, if any

For col D:

Put in D2

: =IF(ISBLANK(C2),B2,C2)

Copy down as many rows as there is data in col A

Col D will return the result of the look-up from col B,
or the non-stock item description you entered in col C
(if any), with the latter taking precedence

Use col D as the reference "Description" column

--
Rgds
Max
xl 97
 
Back
Top