IF then INDEX, Match help

Options

I'm having trouble apply my index formula to pull from multiple sheets depending on one criteria (client). I have three client data sheets, WHI, BCN and WHB and I want to pull the same Check% from each sheet depending on the the client. I was original thinking I need an IF WHI client, then INDEX formula. I basically need to combine these formulas so they can be populated based on client.

Current formulas:

=INDEX({WHI - Check%}, MATCH([Project Name]@row, {WHI - Project ID}, 0))

=INDEX({BCN - Check%}, MATCH([Project Name]@row, {BCN - Project ID}, 0))

=INDEX({WHB - Check%}, MATCH([Project Name]@row, {WHB - Project ID}, 0))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!