Excel search

  • Thread starter Thread starter Jenni @ Heindl's Car and Truck Sales
  • Start date Start date
J

Jenni @ Heindl's Car and Truck Sales

I'm trying to set up a call log of customers for each
month and I was wondering if there was a way to search on
an Excel sheet for a certain name or number w/o having to
scroll through each cell?
 
Have you tried Edit / Find?

Or are you trying to do something a little more elaborate?

/i.
 
Jenni,

Since you provided no info, i'll make assumptions.

You have 5 columns each of which you want to pull back
You have 2 empty rows above your data entry
Columns like Name, Number, Taken By, Start Time, Duration
In A1 put "Search Name" in C1 put "Search Number"
In A2 put =VLOOKUP(B1,A5:E1000,1,False)
In B2 put =VLOOKUP(B1,A5:E1000,2,False)
In C2 put =VLOOKUP(B1,A5:E1000,3,False)
In D2 put =VLOOKUP(B1,A5:E1000,4,False)
In E2 put =VLOOKUP(B1,A5:E1000,5,False)
Then if a Name is entered in B1, A2:E2 will be filled

In A3 put =INDEX(A5:A1000,MATCH(D1,B5:B1000,0))
In B3 put =VLOOKUP(D1,B5:E1000,1,False)
In C3 put =VLOOKUP(D1,B5:E1000,2,False)
In D3 put =VLOOKUP(D1,B5:E1000,3,False)
In E3 put =VLOOKUP(D1,B5:E1000,4,False)
Then if a number is entered in D1, A3:E3 will be filled

Dan E
 
Back
Top