i have been using excel 2010 for a few days now, but i have got a few problems about vlookup and match. they just keep displaying #NA
does it matter all cells are in gerenal?
=VLOOKUP(M2,A2:K7,2,FALSE)
M2= 55
A2:K7- A is reference number
B is name
D7 is same as M2 (55)
the formula above...