Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to autofill a column if criteria is met for Excel 2003
Why not use VLOOKUP to return the description of the item from the catalog
sheet? For example, if the item & description are listed in columns A & B on the catalog sheet, your cell C15 (on the other sheet) could habe the formula: =IF(ISERROR(VLOOKUP(B15,Catalog!A:B,2,FALSE)),"",V LOOKUP(B15,Catalog!A:B,2,FALSE)) Then copy the formula to as many rows as needed. Hope this helps, Hutch "Natalie" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to autofill a column if criteria is met for Excel 2003
thanks so much for the help - that did just what I needed.
Natalie "Tom Hutchins" wrote: Why not use VLOOKUP to return the description of the item from the catalog sheet? For example, if the item & description are listed in columns A & B on the catalog sheet, your cell C15 (on the other sheet) could habe the formula: =IF(ISERROR(VLOOKUP(B15,Catalog!A:B,2,FALSE)),"",V LOOKUP(B15,Catalog!A:B,2,FALSE)) Then copy the formula to as many rows as needed. Hope this helps, Hutch "Natalie" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need formula that will sum cells in a column bases on criteria in other cells. | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions |