Look-up Formula Logic Update

[bdav1216]

Hello,

I have the following look-up formula:

=IFERROR((VLOOKUP(AG2,Sheet2!$L$2:$M$617,2,0)),"N/A")

I would like to add a condition to this formula that says:

IF Column BD = Hello, then return a value of "MK" regardless of the look-up value.

Essentially, this logic should override the value returned from the look-up table

**

If there's a way to modify the look-up table to accommodate this to avoid updating the formula, that would also make sense and would be my preferred solution.

How would the above formula be updated to evaluate a 3rd column?

Currently when AG2 in Sheet1 matches Column L of Sheet2, the value of Column M is returned.

Is there a way to add Column K in the lookup? Basically, when Column K is populated, that is the value that should be evaluated. If it is blank, use the current Column L.

Sheet 2 Current:

Column L Column M
West ABC
South XYZ
North EFG

Sheet 2 Proposed:

Column K Column L Column M
West ABC
South XYZ
North EFG
Hello East MK
Bye West MK

 

[Fluff]

The simplest way is to modify the formula like
=IF(BD2="Hello","MK",IFERROR(VLOOKUP(AG2,Sheet2!$L$2:$M$617,2,0),"N/A"))

 

[bdav1216]

The simplest way is to modify the formula like
=IF(BD2="Hello","MK",IFERROR(VLOOKUP(AG2,Sheet2!$L$2:$M$617,2,0),"N/A"))

Thank you. The formula does work so very helpful.

If I had more than 1 value other than "Hello", how would I update?

For example:
If the value in Column BD = "Hello", override lookup to output a "MK"
If the value in Column BD = "Bye", override lookup to output a "SH"
If the value in Column BD = "NO", override lookup to output a "JP"

 

[Fluff]

How about
=IFERROR(INDEX({"SH","MK","JP"},MATCH(B2,{"Bye","Hello","NO"},0)),IFERROR(VLOOKUP(AG2,Sheet2!$L$2:$M$617,2,0),"N/A"))