if cell equals value then return answer

**swfarm** · 07-02-2018, 06:19 AM

hi guys

im trying to get an answer returned in a cell based on what is selected in D1

if d1 = sai then return answer from P77
if d1 = saiwro then return answer from P77
if d1 = saod then return the answer from P62
if d1 = socc then return the answer from P62
if d1 = so then return the answer from P62

Thanks in advance

**than_gold** · 07-02-2018, 06:42 AM

Hi, Do you want to return the answer to D1?
Could you please post with sample excel?

**rorya** · 07-02-2018, 06:42 AM

Assuming you want something like a 'blank' if D1 isn't any of those, you can use this:

=if(OR(d1={"sai","saiwro"}),P77,IF(OR(D1={"saod","socc","so"}),P62,""))

**swfarm** · 07-02-2018, 06:54 AM

Thank you rorya much appreciated

**rorya** · 07-02-2018, 06:56 AM

Glad to help.

if cell equals value then return answer

LinkBack

Thread Tools

Rate This Thread

Display

if cell equals value then return answer

Re: if cell equals value then return answer

Re: if cell equals value then return answer

Re: if cell equals value then return answer

Re: if cell equals value then return answer

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] If a cell in a column equals today's date return the value of another cell adjacent to it

[SOLVED] Return entire row if cell equals

[SOLVED] If the answer to the formula equals 0, then add 1

return unique list if cell value equals a1

First data in a range that equals less than zero, return another cell

VB Scrip Help - IF CELL EQUALS VALUE THAN RETURN VALUE FROM COLUMN WITH SAME TITLE

Find first value that equals 0 or less and return the cell address

Bookmarks

Bookmarks

Posting Permissions