Re: vlookup or if function to autofill help
Try the attached.
It needs the helper columns on both sheets as I can't think of another way to do it without the helper columns
You can make copies of the sheet for all your LGE types, then type in the appropriate LGE number in cell L1 on the LGE specific sheets.
You can hide the columns if you don't want to view them.
Let me know if it works.