Related Posts
Join us for our first virtual panel on Tonight, Wednesday May 20th at 5 PM EST, Navigating the Ad Industry When the Economy Sucks. Tom Christmann & Paul Fix, award-winning ad creatives and co-deans at Adhouse, will be joining us and taking questions.
https://zoom.us/j/94553752267
More info and calendar links in comments.
Free Worksop: Book Study Club……I will be conducting an 8 week workshop on the book “The Energy Codes” You just need to purchase the book from Amazon. If you are interested please email me at hopecerda@ccceccoaching.com and I will send you the zoom link and more info. for date and time.
Thank you, Hope
More Posts
Anyone working in T-Systems here?
Additional Posts in Accounting
My calculator is talking my back to me....
Xlookup is the way
+1 xlookup
Probably best to wait until Monday morning and ask one of the staff to show you the ropes on Excel
I didn’t mind. I work in industry, so this doesn’t happen frequently. Plus, index match saved me about an extra hour of time.
I figured it out. Thank you for the moral support!
Go little rockstar!
Did you try YouTube? That’s where I get many of Excel, Tableau and Alteryx questions answered.
Op - way to catch it. I had this issue with a vlookup the other day and nearly lost it and until I realized everything wasn’t the same format. Glad you got it to work!
Whenever I use these functions, I start with the “match” and make sure it’s correct. THEN, I’ll add the index to the beginning of the formula.
Have you tried vlookup or hlookup too?
I’m creating a table where index match would be better.