Some type of look up formula needed
Hello Experts!
I have a sheet that is compiling a lot of project information for P&L purposes. I need to find a formula that will enter the Project Manager for a Job number (each time it appears). I think the best place to pull that from is my project intake sheet. Please see below screenshots. Can someone recommend a formula to accomplish this?
Best Answer
-
Hey @Micah Turner
I would recommend an Index/Match for the lookup. For this specific instance, the formula below should work
=INDEX({Project Intake Sheet Project Manager column}, MATCH([Job Number]@row, {Project Intake Sheet Job Number column},0))
When referring to another sheet (cross sheet reference), once must build each reference physically using the formula window - one cannot simply copy paste this formula into your sheet. Your ranges will appear different - that is to be expected. I named them so you can see exactly what the range is.
Will this work for you?
Kelly
If interested, this article provides information on cross sheet references
Answers
-
Hey @Micah Turner
I would recommend an Index/Match for the lookup. For this specific instance, the formula below should work
=INDEX({Project Intake Sheet Project Manager column}, MATCH([Job Number]@row, {Project Intake Sheet Job Number column},0))
When referring to another sheet (cross sheet reference), once must build each reference physically using the formula window - one cannot simply copy paste this formula into your sheet. Your ranges will appear different - that is to be expected. I named them so you can see exactly what the range is.
Will this work for you?
Kelly
If interested, this article provides information on cross sheet references
-
That worked. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!