# Locating a certain cell in a excel file

#### rbpd5015

##### New Member
Ok guys I am working on a spreadsheet and need a little help please.

I have a column called series it is column C and a column called game it is column D.

I want to write a formula to call a certain series and game number

for example

if the current row I am on is series = 3 game = 2.

Now I want to located a cell in the row where series = 3 and game = 1.

how would I do that?

This is because I have the spreadsheet entered by date so you get this

series 1 game 1
series 2 game 1
series 3 game 1
series 1 game 2
series 3 game 2
series 4 game 1
series 5 game 1
series 6 game 1
series 5 game 2
series 6 game 2
series 5 game 3

etc (This is just random but it is to make my point).

So I got a cell called To win and it always = the sum of the previous games of that series.

so using the example above The To Win cell for Row Series 5 game 3 = Row Series 5 game 2 Cell To Risk + Row Series 5 game 1 Cell To Risk.

Does this make sense?

Any help would be greatly appreciated.

Matt

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Replies
9
Views
517
Replies
10
Views
488
Replies
3
Views
970
Replies
6
Views
469
Replies
4
Views
342

1,191,374
Messages
5,986,274
Members
440,016
Latest member
vasanrajeswaran

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back