Hello Everyone,
I am trying to create a spreadsheet for a game I am playing. Essentially it will add up multiple resources from different players. Essentially the player details are entered in a spreadsheet which contains all the mixed data from all the users. I was then going to create a balance sheet for each player. I would then carry that balance over to an overview sheet. My problem is getting my look up value working.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD="align: center"]Transaction[/TD]
[TD="align: center"]Electricity[/TD]
[TD="align: center"]Oil[/TD]
[TD="align: center"]Uranium[/TD]
[/TR]
[TR]
[TD]=VLOOKUP($B$1,'Form responses 1'!$B$2:$G18000,6)[/TD]
[TD="align: right"]=VLOOKUP($B$1,'Form responses 1'!$B2:$G$18000,3)[/TD]
[TD="align: right"]=VLOOKUP($B$1,'Form responses 1'!$B2:$G$18000,2)[/TD]
[TD="align: right"]=VLOOKUP($B$1,'Form responses 1'!$B2:$G$18000,4)[/TD]
[/TR]
[TR]
[TD]Deposit[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8000[/TD]
[/TR]
[TR]
[TD]Deposit[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8000
[/TD]
[/TR]
</tbody>[/TABLE]
My problem is the formula works but only for the first line not beyond that.
I deally I would like the formula to look for the username in B1, then search the 'Form responses 1' sheet and give me the relevant information. Once that entry has been entered then move onto the next entry in the list for that user.
I hope this makes sense.
I am trying to create a spreadsheet for a game I am playing. Essentially it will add up multiple resources from different players. Essentially the player details are entered in a spreadsheet which contains all the mixed data from all the users. I was then going to create a balance sheet for each player. I would then carry that balance over to an overview sheet. My problem is getting my look up value working.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD="align: center"]Transaction[/TD]
[TD="align: center"]Electricity[/TD]
[TD="align: center"]Oil[/TD]
[TD="align: center"]Uranium[/TD]
[/TR]
[TR]
[TD]=VLOOKUP($B$1,'Form responses 1'!$B$2:$G18000,6)[/TD]
[TD="align: right"]=VLOOKUP($B$1,'Form responses 1'!$B2:$G$18000,3)[/TD]
[TD="align: right"]=VLOOKUP($B$1,'Form responses 1'!$B2:$G$18000,2)[/TD]
[TD="align: right"]=VLOOKUP($B$1,'Form responses 1'!$B2:$G$18000,4)[/TD]
[/TR]
[TR]
[TD]Deposit[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8000[/TD]
[/TR]
[TR]
[TD]Deposit[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8000
[/TD]
[/TR]
</tbody>[/TABLE]
My problem is the formula works but only for the first line not beyond that.
I deally I would like the formula to look for the username in B1, then search the 'Form responses 1' sheet and give me the relevant information. Once that entry has been entered then move onto the next entry in the list for that user.
I hope this makes sense.