IF then INDEX, Match help

ATB

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))

Ramzi K

Assuming your client name is in a column called Client, your formula would look something like this:

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

Hope that works for you.

Ramzi

Ramzi K

Assuming your client name is in a column called Client, your formula would look something like this:

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

Hope that works for you.

Ramzi