Forum Discussion
SJBSLAM
Jun 03, 2022Copper Contributor
copying data from a single field into many
I am hoping you wonderful people may be able to answer a question for me. I am working with a group of separate but related spreadsheets and wish to combine the information. For background, I work ...
- Jun 03, 2022
=VLOOKUP($H2,'demographic information'!$A$2:$G$27,COLUMN('demographic information'!B1),FALSE)Is this similar to what you are looking for?
OliverScheurich
Jun 03, 2022Gold Contributor
=VLOOKUP($H2,'demographic information'!$A$2:$G$27,COLUMN('demographic information'!B1),FALSE)Is this similar to what you are looking for?
SJBSLAM
Jun 06, 2022Copper Contributor
OliverScheurich That's fantastic; thank you so much!