Hey Guys,
I have a spreadsheet with two tabs (sheet1 and sheet2). Sheet1 has data in it, and sheet two is where I wish to pull data into from sheet1.
My data is set out similarly to the attached, but it is huge. I would like in sheet two to be able to to somehow tell excel to "FIND A SPECIFIC UNIQUE IDENTIFIER, AND PULL IN THE INFORMATION THAT LIES IN THE TWO CELLS TO THE LEFT OF IT". So here basically i want to say look for the unique identifier and then pull in the game time and run time for it.
is there a way to do this?
Thank you in advance
Games.png
Game Times.xlsx
Bookmarks