I want to automatically populate cell H6 using the chart I have in my
spreadsheet.
if cell G8 = B17 then cell H6 = D17. If G8 = B16 then cell H6 = D16, and so
on.
I know this isn't a true if statement as there is not false. How would I do
this?
Thank you, Anita