need a formula to look up values in two columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

veena - 28 May 2008 21:52 GMT

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

Reply to this Message

Marcelo - 28 May 2008 21:55 GMT

on e2 use

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

hth

Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

> 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
[quoted text clipped - 11 lines]
> 8 281 9879 499 399
> 9 282 6965 499 299

Reply to this Message

veena - 28 May 2008 22:10 GMT

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

> on e2 use
>
[quoted text clipped - 17 lines]
> > 8 281 9879 499 399
> > 9 282 6965 499 299

Reply to this Message