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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limit drop down items based on another cell 3
Excel does not accept text format! 0
Dragging a formula in a column 1
IOS App: Contacts in search or in new mail not found 0
Possible Sumproduct with Or Function 1
Finding the proper style field and the numbered paragraph value within the style 0
Autonumber field in Excel that behaves the same as Access 0
trouble with (complicated) vlookup searching another workbook 2

Top