Forum Discussion

BP-Moons's avatar
BP-Moons
Copper Contributor
May 02, 2024

Combining RIGHT function with VLOOKUP with multiple conditions

I am trying to write a function that will look up if the last character in A column is "D" or "L" and if this is the case will then move the last character to G column. When i try to enter the ...
excel
Formulas and Functions
  • MAngosto's avatar
    MAngosto
    May 02, 2024

    BP-Moons 

     

    On G1 place:

     

    =IF(OR(RIGHT(A1,1)="L",RIGHT(A1,1)="D"),RIGHT(A1,1),"")

     

    Drag down to fill all cells.

MAngosto's avatar
MAngosto
Iron Contributor
May 02, 2024

BP-Moons 

 

On G1 place:

 

=IF(OR(RIGHT(A1,1)="L",RIGHT(A1,1)="D"),RIGHT(A1,1),"")

 

Drag down to fill all cells.

BP-Moons's avatar
BP-Moons
Copper Contributor
May 02, 2024
This works perfectly thank you, i tried it with an IF Or function to begin with but used the wrong syntax for multiple conditions

Resources