Techtech

Tue Oct 18, 2016, 09:27 PM

I need some Excel help from one of you nerds

Please. Lol...

Ok...I'm using an NCAA type formula/ algorithm that I've created but it takes too long for me to type in values after every team I put in.

How do I type in "BYU" (for example) and it automatically assigns the value assigned to them in another part of the sheet?

I have all of the teams with a rating value. In another part of the spreadsheet I have the upcoming games (Say BYU in column K and Boise St. in column M. Is there anyway to have "114" automatically come up in Column L after BYU as soon as I type them in?

I'll hang up and listen. Thanks.

8 replies, 740 views

Reply to this thread

Back to top Alert abuse

Always highlight: 10 newest replies | Replies posted after I mark a forum
Replies to this discussion thread
Arrow 8 replies Author Time Post
Reply I need some Excel help from one of you nerds (Original post)
Jenny Fromdablock Oct 2016 OP
TheyLostTheirForums Oct 2016 #1
Jenny Fromdablock Oct 2016 #2
TexMex Oct 2016 #6
ProudNYSTaxPayer Oct 2016 #7
Chunga Oct 2016 #3
TheyLostTheirForums Oct 2016 #4
RATFINK_5.0 Oct 2016 #5
Currentsitguy Nov 2016 #8

Response to Jenny Fromdablock (Original post)

Tue Oct 18, 2016, 09:47 PM

1. Actually you can use the hlookup function

Reply to this post

Back to top Alert abuse Link here Permalink


Response to TheyLostTheirForums (Reply #1)

Tue Oct 18, 2016, 10:01 PM

2. Pretend I have no idea what that is.

As if I mentioned time travel and you just said flux capacitor. Lol...

Reply to this post

Back to top Alert abuse Link here Permalink


Response to Jenny Fromdablock (Reply #2)

Thu Oct 20, 2016, 05:45 AM

6. I posted in the other thread already

 

But there's no way around this: you're going to have to build up your Excel knowledge to DIY this project. Otherwise farm this out to someone who knows Excel already. VLookup / Hloolup isn't beginners level Excel. I'd google up a tutorial if I were you. The lookup functions will do exactly what you want, but you have some learning and practice to do before you can use it.

Reply to this post

Back to top Alert abuse Link here Permalink


Response to Jenny Fromdablock (Reply #2)

Fri Oct 28, 2016, 11:18 AM

7. What are your thoughts on INDEX-MATCH?

Ive been using vlookup and hlookup for so long now that it is second hand that I just can't get myself to switch despite the fact that every resource I have seen says it's better.

Reply to this post

Back to top Alert abuse Link here Permalink


Response to Jenny Fromdablock (Original post)

Tue Oct 18, 2016, 10:02 PM

3. =INDIRECT(column row)

Type that into a cell to retrieve info from the cell you specify.

Reply to this post

Back to top Alert abuse Link here Permalink


Response to Chunga (Reply #3)

Tue Oct 18, 2016, 10:10 PM

4. Does that function support a range of cells?

Reply to this post

Back to top Alert abuse Link here Permalink


Response to Jenny Fromdablock (Original post)

Tue Oct 18, 2016, 10:11 PM

5. Simpler than you would think. Cut & Paste function.

Put cursor on right bottom part of cell until '+'symbol appears. About second or less.

Drag down content from previous cell column. Cell will highlight. You can always Copy Paste cells.

Reply to this post

Back to top Alert abuse Link here Permalink


Response to Jenny Fromdablock (Original post)

Tue Nov 1, 2016, 09:04 AM

8. Why are you doing this in Excel?

This sounds more to me like something more suited to a database. I would think it should be built in Access with linked tables to the substitute values.

Reply to this post

Back to top Alert abuse Link here Permalink

Techtech