Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find item in list
I would like to be able to find an item in a certain list of numbers that
matches the criteria in one cell, then apply the number in the cell to the right of the number in the list to a different cell. Confused? So am I...I'll try to give clarification if needed. TIA, Erik |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find item in list
I would like to be able to find an item in a certain list of numbers[listrange] that
matches the criteria in one cell [equals value in F3/valuerange], then apply the number in the cell to the right of the number [TargetRange.offset(0,1)] in the list to a different cell.[M21] set listrange = Range(cells(1,1),cells(1,1).End(xldown)) set valuerange = Range("F3") res = Application.Match(valuerange.Value,listrange,0) if not iserror(res) then set targetRange = listrange(res) Range("M21").Vavlue = TargetRange.offset(0,1) * Range("M21")) End if Might be a start. -- Regards, Tom Ogilvy "XL Dunce" wrote in message news:1112367157.03ebbb270c16095daa545e92423372fb@t eranews... I would like to be able to find an item in a certain list of numbers that matches the criteria in one cell, then apply the number in the cell to the right of the number in the list to a different cell. Confused? So am I...I'll try to give clarification if needed. TIA, Erik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To find rate of each item from item.xls and to copy price.xls | Excel Discussion (Misc queries) | |||
List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
I need to pair each item on one list to each item on another list | Excel Worksheet Functions | |||
Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions |