Why is this formula not working?

[kzaveri19]

Hi,

I Want to have two tables calculating different values based on a type of vendor, which then feed into a sort of a "heat map". I am using the following formula

Please Login or Register  to view this content.

Currently, both tables referenced ($B$153:$AW$173 and hsc!$B$3:$AW$23) are EXACTLY the same.

However, the formula fails for "value_if_false" section of the "if" statement. Is there anything I am doing here wrong?

The column part of the second index-match (MATCH($D7,hsc!$B$3:$AW$23,0)) is the one failing


Please help!!

Thanks

[FlameRetired]

Hi kzaveri19 and welcome to the forum.

Have you checked for leading or trailing spaces in D7 and hsc!$B$3:$AW$23?

If that doesn't resolve the formula try uploading a sample work book ... data desensitized.

If you are not familiar with how to do this:

To attach a file to your post,

• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

[Pete_UK]

You can only use MATCH on a one-D array, so I think that term should be:

(MATCH($D7,hsc!$B$23:$AW$23,0))

Hope this helps.

Pete