Help with lookup formula across multiple columns

[keasha]

hello
i hope someone can please help. i have uploaded a sample file for you.

i have data in multiple columns (see data tab)

in the first tab (x schedule view) i need to be able to look up the data depending on the columns and return the $$ value. i.e the first tab should return all the values relevant to the provider (column c) into the columns from D to K.

hope someone can please help !

 

[bosco_yip]

Try,

1] Set up a Validation List at B4, for selection of region.

2] In D5, copied across and down :

=SUMIFS(data!$H:$H,data!$F:$F,IF($B$4="All","<>",$B$4),data!$E:$E,$C5,data!$C:$C,D$3,data!$B:$B,D$4)

3] Select D5:K8 >> Format Cells >> Number >> Custom, in the Type box enter :
_-$* #,##0.00_-;-$* #,##0.00_-;;

Regards
Bosco

 

[keasha]

Hi Bosco
Ok i see, i will give that a go. thankyou so much for getting back to me, i will let you know how i go , keasha

 

[keasha]

all good - might be in touch for something else if thats ok