troubleshooting Question

excel formula two tabs

Avatar of Matt Pinkston
Matt Pinkston asked on
Microsoft Excel
4 Comments2 Solutions295 ViewsLast Modified:
I have an excel workbook with two tabs (tab1 & tab2)

tab1 is my main tab with a bunch of columns, column1=jobid and column2=status.  The status columns is currently blank but I want to get it from tab2

tab2 has only two columns, jobid and status

how do I make the status column in tab1 grab the status in tab2 when jobid=jobid
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros