Steviefiege
Board Regular
- Joined
- Aug 29, 2018
- Messages
- 66
Hi,
I've got a list of numbers that are all the same (eg. 80,80,80,80,80) The first vlookup is fine as it matches the first 80 to the cell i want it to. Is there a way to match the 2nd 80 to the 2nd cell along the list as a normal vlookup will just lookup the first one wouldnt it.
Here's what i've done. I'm making a betting spreadsheet as shown below:
Over 2.5 80
BTTS 80
Exactly 2 Goals 80
Away Team Exactly 1 Goal 80
BTTS & Under 3.5 80
How would i get my spreadsheet to say the above instead of in every one saying Over 2.5?
Also, in my spreadsheet it goes acoss, not down. Just did the above as an example.
Rgs
Steve
I've got a list of numbers that are all the same (eg. 80,80,80,80,80) The first vlookup is fine as it matches the first 80 to the cell i want it to. Is there a way to match the 2nd 80 to the 2nd cell along the list as a normal vlookup will just lookup the first one wouldnt it.
Here's what i've done. I'm making a betting spreadsheet as shown below:
Over 2.5 80
BTTS 80
Exactly 2 Goals 80
Away Team Exactly 1 Goal 80
BTTS & Under 3.5 80
How would i get my spreadsheet to say the above instead of in every one saying Over 2.5?
Also, in my spreadsheet it goes acoss, not down. Just did the above as an example.
Rgs
Steve
