Lookup Problem

	A	B	C	D	E	F	G	H	I	J	K	L
1	Name	Last Zone Visited	Otherdata	Otherdata	North	South	East	West	Northwest	Northeast	Southwest	Southeast
2	Smith	Northeast	asodgjfh	aoijga		ab	ab	cd	cd	xy
3	Jones		aoihfa	apoihfa
4	King	West	aoijg	aoiuhfa	ab			rw
5
6
7				Need a formula in Col B that will find the LAST non-blank cell in each row (from col E thru L) , and return it's column header into column B, as shown, or return a blank if nothing in the range.
8				The "Otherdata" columns are there just to show that the working areas are not next to each other, in case that matters.
9				I had a working formula in Excel, but it only gave me a blank cell in Google Sheets.>>>>>>>>>							=IFERROR(LOOKUP(2,1/(E2:L2<>""),E$1:L$1),"")
10				This is not the actual type of data I'm working with, but I'm just using this for the sake of simplicity.
11				Also, I am a layperson when it comes to spreadsheets, and only obtained the Excel formula by copying others until it worked.
12				So I may not understand some jargon.
13				Hope there IS a formula for this!
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100