if/ then

Hi Guys, Columns B, C, D, and E contain a list look-up (Yes or No) Earlier today, you guys helped me that if column B and/ or E has "Yes", to return certain text (Thank you!) I placed the updated functionality in column F. Then I wanted the user to identify the scope of work based on the...

I have the following code from a previous project i worked on and tried to modify it to find the value of a cell in column A and if the value matches, then display the two adjacent cell values in the two textboxes i have on the user form: Dim i As Integer Dim arrIn As Variant Dim arrOut() Dim j...

I'm having trouble coming up with a formula that will check for certain conditioners in a specific order. Any help is appreciated. If D144 is blank and E144 is not ‘Specific Text A or Specific Text B’, return E144. If D144 is Blank and E144 contains ‘Specific Text A’ return ‘Specific Text X’...

Hi, I can't seem to find a previous post close enough to what I'm trying to accomplish. Also, I don't know if this is possible with Excel formulas or if VBA must be used as well. Below I have an API that shows stock prices, volume, etc. Columns J and K have Combo Boxes and column N has Check...

I want to reference one spreadsheet's data on another sheet. In the first sheet containing all the data, I have months in ROW 1 January-December. In rows 4-8, I have values according to different variables. It looks somewhat like this: <tbody> Month Jan Jan Mar Mar Mar Apr May Date 1/7 1/28...

Hello, I am trying to use an If /Then Statement in order to change the output of a program I am making. I want to be able to change the value of a cell (through a data validation dropdown), change a certain output and have this happen after a certain Option Button is selected. For Example...