I have a template with various columns to be filled, with the data being pulled from another data set (I have both in the same sheet for now and will just paste special values out later). Things gets complicated since the data set from which I'm taking data has the information in 2 rows, but the final template needs to have the info in one row. There is a common identifier with which I can match things (i.e. 2 rows of data to pull and each row has the common identifier). I have matched using this identifier but it does not work fully since I also need to tell Excel to pull from one of the 2 rows based on a conditional statement. I don't know how to do this but I'm guessing I have to nest IF statements here somewhere.
For reference I am currently using: =INDEX($C$236:$W$451, MATCH($B$14,$C$236:$C$451,0),13)
To help make it a bit clearer, each row in the data set is either Pay or Receive. And in the final template, it is one consolidated row with half of the columns being 'Pay' and half being 'Receive'. For the data set source, I think I need to match to the common identifier, and then if the first row is Pay pull the relevant data in this row to columns in the left/'Pay' side of the final template. Or if it's receive, pull it to the relevant columns on the right/'Receive' side of the final template.
I have been trying to do this myself on and off for about 3 days now, so any help is greatly appreciated.
Thanks!
Bookmarks