If then formula (I think)

Hi all! I'm fairly inexperienced in the higher Excel functions and need some help. I'm putting together a quoting spreadsheet that will also generate a shopping list. Here's what I've got where there is my problem. In one section I've got a drop down menu in my Supplies column, Q10. One of the choices is "Miscellaneous". If I choose that, then I need to manually enter into R10 the item, let's say Pencil. In my shopping list section, in cell AH33 I want to write a formula that in effect says, if Q10 is "Miscellaneous" then enter the value in cell R10. If it is not "Miscellaneous", then enter the value in Q10. Is this possible? I spent 2 hours on the phone with Microsoft and it took me most of that time explaining this to the support person, who then fobbed me off to another person who then directed me to yet a third person.... Any help would be so deeply appreciated!

Hi,

Try this:

Formula:

Please Login or Register  to view this content.

THANK YOU!!!! THAT WORKED AND I LEARNED SOMETHING NEW!

Thank you so much!

You're welcome, thanks for the feedback.