Help with formula

VaneT

Hello,

I have been trying to fix the following formula in Smartsheet but I continue getting the #UNPARSEABLE error message. Can someone help me fix it?

=IFERROR(INDEX({Reference Range 4}, MATCH([Job Level]@row, {Reference Range 5},0)MATCH(Region@row, {Reference Range 6},0)),0)

Reference Sheet:

BullandKhmer

I'm not sure what you are trying to achieve, but one of the below should work:

=IFERROR(INDEX({Reference Range 4}, MATCH([Job Level]@row, {Reference Range 5},0)),INDEX({Reference Range 4},MATCH(Region@row, {Reference Range 6},0)))

=IFERROR(INDEX(COLLECT({Reference Range 4}, [Job Level]@row, {Reference Range 5},Region@row, {Reference Range 6}),1),0)

VaneT

@BullandKhmer Thank you for your help; unfortunately, none of those two formulas worked. I would like the cell to automatically bring up the salary $ based on the region and job level.

For instance, someone at the USA in a 32-Sr Manager level would make $42, 254. But the formula is not working or maybe I am using the wrong formula...

BullandKhmer

Its a simple index collect formula. check out smartsheet formulas and figure it out for yourself.

ker9

Towards the bottom of this is the info you need:

https://community.smartsheet.com/discussion/86632/create-report-with-text-from-multiple-columns-but-stacked-vertically-in-rows