| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF cell equals then help
To all,
I need help with the following. I have a list of part numbers in column A. In column D I have a list of part numbers. In column E I have a price for these part numbers. Is there anyway that I can loop through column A so that it matches the part number to that of column D, and then Assigns the price ( Column E) to column B automatically if it matchs,without having to go through manually and allocating the price? Please let me know if you need anymore info. Thanks in advance for your help, Regards Joseph Crabtree |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If a cell equals _, at the next row that equals _, return value fr | Excel Worksheet Functions | |||
| If cell is left blank, or equals zero, then cell equals a different cell | Excel Discussion (Misc queries) | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
| custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
Threaded Mode
