LOOKUP HELP PLEASE
 

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?

LOOKUP HELP PLEASE
 

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
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Zakynthos" wrote in message
...
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?