Hello
Thanks in advance for your help and support.
Is there a formula that would accomplish the following?
if tab 1, A4:37 = Diesel then the value from tab 2 cell e3 should appear in tab 1 column b
if tab 1, A4:37 =Apples then the value from tab 2 cell e4 should appear in tab 1 column b
if tab 1, A4:37 =tires then the value from tab 2 cell e5 should appear in tab 1 column b
if tab 1, A4:37 =betty then the value from tab 2 cell e6 should appear in tab 1 column b
Thank You
James
Bookmarks