need a formula to look up values in two columns

V

veena

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
 
M

Marcelo

on e2 use

=if(d2<>0),d2,c2)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"veena" escreveu:
 
V

veena

the bracket after the zero was giving me an error but after removing it this
works. thank you soo much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula reqd. 4
Look Up Multiple Values in a Column based on single Criteria 3
Finding quantity that falls within a range or Tier 3
Trying To Put IFs into a Function 3
Look up two values in different columns and return matching value 5
Can only process 50 WORD documents at a time 0
A formula to auto-update a classification ONLY if it goes UP 3
series of formulas to get to one formula 0

Top