Hello, I have a workbook that has 7 data sheets and a front main sheet. I have it set up so when you type a "NAME" into a main cell on the main sheet, it will auto populate the main sheet with a bunch of data from the 7 data sheets. I'm needing it to go from one sheet to the next to find and fill the data.
I'm using the below formula but it will only work up to the first two vlookups. When I add the third, I receive an error message stating....
IFERROR(VLOOKUP('Golden Ticket'!B10,'Schacht~'!$C:$AF,FALSE),(VLOOKUP('Golden Ticket'!$B$10,'Goodsen~Barton'!$C:$AF,30,FALSE),(VLOOKUP('Golden Ticket'!$B$10,'Parks~Banks'!$C:$AF,30,FALSE),(VLOOKUP('Golden Ticket'!$B$10,'Maxey~Thurman'!$C:$AF,30,FALSE),(VLOOKUP('Golden Ticket'!$B$10,'Fox~Walker'!$C:$AF,30,FALSE),(VLOOKUP('Golden Ticket'!$B$10,'Hanesworth~Cordell'!$C:$AF,30,FALSE),(VLOOKUP('Golden Ticket'!$B$10,'Johnson~Cooley'!$C:$AF,30,FALSE))))))))
Golden Ticket B10 is the main cell on the main sheet you type in the "Name", after that are the sheet names/cells to vlook at, then column to view.
Anyone know why I can't go past two vlookups?
Any help would be appreciated.
Thank you
I'm using the below formula but it will only work up to the first two vlookups. When I add the third, I receive an error message stating....
IFERROR(VLOOKUP('Golden Ticket'!B10,'Schacht~'!$C:$AF,FALSE),(VLOOKUP('Golden Ticket'!$B$10,'Goodsen~Barton'!$C:$AF,30,FALSE),(VLOOKUP('Golden Ticket'!$B$10,'Parks~Banks'!$C:$AF,30,FALSE),(VLOOKUP('Golden Ticket'!$B$10,'Maxey~Thurman'!$C:$AF,30,FALSE),(VLOOKUP('Golden Ticket'!$B$10,'Fox~Walker'!$C:$AF,30,FALSE),(VLOOKUP('Golden Ticket'!$B$10,'Hanesworth~Cordell'!$C:$AF,30,FALSE),(VLOOKUP('Golden Ticket'!$B$10,'Johnson~Cooley'!$C:$AF,30,FALSE))))))))
Golden Ticket B10 is the main cell on the main sheet you type in the "Name", after that are the sheet names/cells to vlook at, then column to view.
Anyone know why I can't go past two vlookups?
Any help would be appreciated.
Thank you