| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to look up a column and paste results in another column
I've tried to use Vlookup for this but was unable to get it working.
Here's what I need: In column 3 I have: dog dog1 cat cat2 I'm trying to get an inventory management tool by looking at column 3 and subtracting 1 from the previous row, so I would have: Column 3 Column 4 for dog Column 5 for dog1... 100 dog 99 dog1 0 cat 0 cat2 0 dog 98 So, if I have "dog" in row 3 then I get a formula to look up "dog" then subtract 1 from the previous row (or previous valid number, maybe not 0) and give me the result, and if it is not "dog" it'd show a 0. Hope I was clear enough... PLEASE HELP! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to find text string in a column and paste data in another | Excel Discussion (Misc queries) | |||
| Paste results consecutively within column (based off other worksheet) | Excel Worksheet Functions | |||
| Effective method to paste array formula | Excel Worksheet Functions | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
| Entering Same Formula to A Full Staring from Say Row 5 Column..... | Excel Worksheet Functions | |||
Threaded Mode
