Looking for VLOOKUP formula to pull data from mulitple sheets
I am attempting to use a VLOOKUP formula to pull data across multiple sheets. Since Smartsheet does not have the capability (yet, I hope!) to merge multiple form submissions onto one row, I am creating 2 other data collection sheets and need to pull that data to my master sheet. Each sheet has a unique reference number to tie them all together which the formula should recognize and then pull the data from that row to the specified column.
I have tried some formulas suggested that I have found on this forum but currently none of them are working. I am getting an #UNPARSEABLE or #INVALIDREF error.
Does it matter that the unique ref# on my master sheet (primary column) is a formula grabbing the value from a hidden column 2 which is an auto generated alpha-numeric number?
I hope this as makes sense and someone has my solution!
Help Article Resources
Check out the Formula Handbook template!