Hi,
What I'm trying to do is to copy data from a sheet (named Data Source, cell K68) and then paste that data as a value into a second sheet (named Reference) in a specific cell based on an index match/match (indexmatch('sheet 2'O28:V63,match(sheet 1 H67,sheet 2 N28:N63,0),match(sheet 1 F68,sheet 2 O27:V27,0)).
I've been looking online and found some VBAs that will match one of the "keys" but not both. I'm assuming this might be easy, I'm just still pretty new with VBAs.
Let me know if there's any additional data needed
What I'm trying to do is to copy data from a sheet (named Data Source, cell K68) and then paste that data as a value into a second sheet (named Reference) in a specific cell based on an index match/match (indexmatch('sheet 2'O28:V63,match(sheet 1 H67,sheet 2 N28:N63,0),match(sheet 1 F68,sheet 2 O27:V27,0)).
I've been looking online and found some VBAs that will match one of the "keys" but not both. I'm assuming this might be easy, I'm just still pretty new with VBAs.
Let me know if there's any additional data needed
