Index or Vlookup or What?

ryan.diamond55371
ryan.diamond55371 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hey All!

I have a question for the community that i'm having trouble figuring out to return a certain value to another sheet based on criteria. The pic I attached shows a project budget setup and I am wanting to pull data from the Budget cell based on the Job ID and the Cost Category. I'm not sure if it is a Index - Match function or a combination of Vlookup / Hlookup but any help is greatly appreciated!

Index.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!