View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Natalie Natalie is offline
external usenet poster
 
Posts: 44
Default How to autofill a column if criteria is met for Excel 2003

I am attempting to have a worksheet field within Excel 2003 autofill a column
as follows:

If B15 = 120354 then C15 will equal the description defined on catalog
worksheet for item 120354. I tried building an 'IF' clause but it just pulls
the first row of the range I indicate. It does give a literal value to field
B15.

Thanks for any assistance.
Natalie