Forum Discussion
Need help to solve this syntax? contain IF and VLOOKUP
Hi guys.. this is my first post on here.. I have problem to solve this syntax.. here the scenarios: 1. write a word on cell A1 for example Harry or Theo or Tiger 2. then I have a table like this ...
Try this:
=IFERROR(IF(A1<>"";VLOOKUP(LEFT(A1;2);A5:B10;2;FALSE));VLOOKUP(LEFT(A1;1);A5:B10;2;FALSE))
Regarding taking "the 2nd and 3rd char from right" from a text string perhaps this:
=LEFT(RIGHT(A1,3),2)
Let's say the text string is "abcdef", then the formula will return "de".