Search formula

R

RedPanther

It works but only one problem, i have to typ the number and then th
name appears, but i wont it other wise. I wont if i enter the name
get the number, how do i do that
 
F

Frank Kabel

Hi
you could use the same kind of formula. Maybe instead of VLOOKUP try
INDEX / MATCH. e.g.
=INDEX(A1:A100,MATCH("name",B1:B100,0))
 
Top