Situation:
Trying to find the right VLOOKUP formula combined with IF. Data is coming from a table in another sheet but in the same file. Tried this formula but it doesn't work.
My concern, if the input/encoded data in cell G770670 can be found in:
Column 1, it will show CL650 in cell X770670
Column 2, it will show G5000 in cell X770670
Column 3, it will show G6000 in cell X770670
Column 4, it will show G7000 in cell X770670
Column 5, it will show Airbus in cell X770670
Solved by S. U. in 21 mins