how do you search a range of cells...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a sports schedule worksheet. I want to use a variable so I
can change the schedule from year to year without having to reprogram it.

What I want to do is create a formula where it checks the full team name in
D5 and compares it to the master list of team names listed in A1:A32, then
take the corresponding cell B1:B32 (the adjacent list of shortened names) to
enter the results in E5.

If I can get an example with and without a macro, I'd appreciate it.
 
Enter in E5.

=VLOOKUP(D5,$A$1:$B$32,2,FALSE)

don't bother with the macro.
 
Hi!

Here's the "without a macro" version.

In E5 enter this formula:

=IF(D5="","",VLOOKUP(D5,A1:B32,2,0))

Biff
 
You must log in or register to reply here.

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

Tie additional cells to cell automatically updated 1
Inputting cell value from source cell based on value in adjacent cell. 3
SUMPRODUCT formula help 7
How not to show "#VALUE" 7
Excel Msgbox runing beyond posted cell range. 1
Extract list of values from a list 6
formula explanation 3
SUMPRODUCT NON-ADJACENT CELLS 2

Back
Top