Q
Qaspec
I need to do some type of lookup and sum in vba
I'd like to use Total Sheet.B5 to return the value
Total Sheet.B5 to = 55 if Total Sheet.A5 = Orange
Total Sheet
A5 = Orange B5 = 55
Sheet 1
A4 = Blue b4 = 5
A5 = Green b5 = 10
A6 = Orange b6 = 15
Sheet 2
A4 = Orange b4 = 10
A5 = Green b5 = 20
A6 = Blue b6 = 30
Sheet 4
A4 = Green b4 = 20
A5 = Orange b5 = 30
A6 = Blue b6 = 40
Thank you for any help
I'd like to use Total Sheet.B5 to return the value
Total Sheet.B5 to = 55 if Total Sheet.A5 = Orange
Total Sheet
A5 = Orange B5 = 55
Sheet 1
A4 = Blue b4 = 5
A5 = Green b5 = 10
A6 = Orange b6 = 15
Sheet 2
A4 = Orange b4 = 10
A5 = Green b5 = 20
A6 = Blue b6 = 30
Sheet 4
A4 = Green b4 = 20
A5 = Orange b5 = 30
A6 = Blue b6 = 40
Thank you for any help