LOOKUP HELP PLEASE

[Zakynthos]

N1 and O1 contain examples of my lookup values "361A" and "362B".
H1 AND H2 are the vectors containing these variables.
E1 contains the names I want to input to L1, L2 etc and M1,M2 etc respectively
The LOOKUP formula I've used seems to work in L1: (where H1 contains "361A")
butdoesn't work in M1.

I used: =LOOKUP($N$1,H1,E1) in L1 (that's fine) and
=LOOKUP($O$1,H1,E1) in M1 (where I got the same result as in L1, same name)
As O2 and H2 both contained the value "362B" I would have expected to get a
#n/a in M1 and the name in E2 returned to M2. M2 has the correct result but
M1 doesn't. Also as H3 contains the same value as H1 "361A" I should get a
#n/a there as well, shouldn't I? However I get the name from E3 returned
instead of a #n/a.
Where am I going wrong?

 

[Bernard Liengme]

I suggest you look at
http://www.contextures.com/xlFunctions02.html

And then Google: excel vlookup
And view some tutorials

Then come back if you need more help
best wishes