VLOOKUP/IF Formula Question -- What's the best way to accomplish this?

Kristina Kazakoff

Hi all,

I'm struggling with utilizing an if statement with a lookup table in a reference sheet. I've tried a few different combinations and all return an incorrect argument error. To be honest, I'm not sure that utilizing either of these functions is my best route to take.

This is what I want to accomplish:

If the Date corresponds with the Date on the reference sheet then I want to return the number in the next column on the reference sheet for the same row that Date appears in. The purpose of this sheet is to house daily values for numerous other sources to use as a data source for a dashboard.

My reference sheet is set up the same way:

Any input if greatly appreciated!

Thank you,

Kristina

David Joyeuse

Hi @Kristina Kazakoff

You're looking for some INDEX/COLLECT here.

=INDEX(COLLECT({Active Patients Per Day Range}, {Source Range}, [Source]@row, {Day Range}, [Day]@row),1)

Then replace the Range if you want to do it alike for Active Telemetry Patients.

Hope it helped!