Formula / Multiple Sheet Reference Assistance
Hello!
I have a summary sheet that references five sheets. I already had to modify my ranges for VLOOKUP on those sheets because I hit that 25,000 cell reference within moments. Three weeks later after changing all of my sheets, I'm ready to proceed to the next step in my project.
I have one column that uses a VLOOKUP to reference a range on one sheet and pull in a crew assignment based on a unique work order #. I have three contractors with individual sheets. I would like to use the previously mentioned contractor assignment to search out the unique work order number on the individual contractor sheets to pull in project duration, start date, finish date, and % complete information.
My understanding of the formula is something similar to this (but obviously the below is not correct or I wouldn't be asking for help):
=IF([Crew] = "Contractor 1", =(VLOOKUP([WO#], {Contractor 1 Range}, 3, false)) =IF([Crew] = "Contractor 2", =(VLOOKUP([WO#], {Contractor 2 Range}, 3, false)) =IF([Crew] = "Contractor 3", =(VLOOKUP([WO#], {Contractor 3 Range}, 3, false))
Any assistance would be greatly appreciated!
Comments
-
Hi Laura,
Looks like you've got an extraneous equal sign and some parens out of place. It also appears that you don't have a specific cell reference for your search criteria and your Crew.
Try something more like this:
=IF([Crew]1 = "Contractor 1", VLOOKUP([WO#]1, {Contractor 1 Range}, 3, false)) =IF([Crew]1 = "Contractor 2", VLOOKUP([WO#]1, {Contractor 2 Range}, 3, false)) =IF([Crew]1 = "Contractor 3", VLOOKUP([WO#]1, {Contractor 3 Range}, 3, false))
Replace the 1s with the specific cells in your sheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!