| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need a formula to look up values in two columns
Hi, I need a formula that will look at the value in the column D and bring in
column E but if the value is 0 in Column D than i want it to bring it from column C. I hope someone can help me with this. A B C D E Str ITEM Current Special PRICE 1 170 1000074 399 249 2 199 4101471 399 199 3 199 1000065 449 249 4 199 1884733 249 0 5 231 1962422 199 0 6 231 1962516 349 0 7 231 10052 249 174.3 8 281 9879 499 399 9 282 6965 499 299 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Values in Rows with Partial Values in Columns | Excel Worksheet Functions | |||
| How do I test values in 2 different columns in a "sumif" formula? | Excel Discussion (Misc queries) | |||
| Formula to count values in two columns | Excel Discussion (Misc queries) | |||
| Copy columns values into separate columns | Excel Discussion (Misc queries) | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Threaded Mode
