Formula Update to evaluate other columns

**bdav1216** · 12-01-2019, 11:22 PM

I currently have a look-up that evaluates Column AI. When Column A has a specific value, Column DI is outputting a specific value. If Column A is blank, a “N/A” is output in Column DI. That is working correctly.

Current formula:
=IFERROR(VLOOKUP(AI2,Sheet1!N:O,2,FALSE),"N/A")

However, I need to evaluate two other columns as part of the formula. Some of the values that have a value of “N/A” can be more accurate if I evaluate two other columns.

How would I update the existing formula to evaluate the other two columns?'

If Column AI = blank then
If Column AG2 = “Hello” OR Column AH2 = “Hello1” or Column AH2 = “Hello2” then output a value of “Greeting”
ELSE
If Column AG2 = “Bye” OR Column AH2 = “Bye1” or Column AH2 = “Bye2” then output a value of “Later”
ELSE
Evaluate the current formula.

**FDibbins** · 12-02-2019, 01:15 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

However, based on your question...
=if(AI2="",if(or(AG2 = "Hello",AH2 = "Hello1",AH2 = "Hello2"),"Greeting",If(or(AG2 = "Bye",AH2 = "Bye1", AH2 = "Bye2"),"Later",your-formula)

**bdav1216** · 12-02-2019, 08:18 AM

I attached a sample to assist:

When Column AI (Column C in this example) is present, use the look-up value. When Column AI (Column C in this example) is blank, then evaluate the other two columns:

If Column AI = blank then
If Column AG2 (Column A in this example)= “Hello” OR Column AH2 (Column B in this example) = “Hello1” or Column AH2 = “Hello2” then output a value of “Greeting”
ELSE
If Column AG2 = “Bye” OR Column AH2 = “Bye1” or Column AH2 = “Bye2” then output a value of “Later”

**FlameRetired** · 12-02-2019, 11:07 PM

If I understand correctly in cell D2 and filled down.

Formula:

Please Login or Register  to view this content.

**Pepe Le Mokko** · 03-25-2020, 09:01 AM

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Formula Update to evaluate other columns

LinkBack

Thread Tools

Rate This Thread

Display

Formula Update to evaluate other columns

Re: Formula Update to evaluate other columns

Re: Formula Update to evaluate other columns

Re: Formula Update to evaluate other columns

Re: Formula Update to evaluate other columns

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Evaluate 2 columns as conditions then return min and max of another column

evaluate and add points then update a sheet

Evaluate columns for sequential numbers and roll up

[SOLVED] Evaluate to columns; compare two columns and return result

[SOLVED] IF formula, to evaluate two columns to return a new value

[SOLVED] Search matching 3 columns and Evaluate Problem

[SOLVED] want sumif function's range to evaluate 2 columns

Bookmarks

Bookmarks

Posting Permissions