15 дек. 2023 г. · You must change the “Value A” expression, for the cell that holds the actual value, and the “List B” expression, for the range that holds the ...

19 июл. 2023 г. · For each cell in the column of full names, I am trying to check if any of the last names in the last name list appear in the column.

16 окт. 2022 г. · I want a formula so that if I type a contractors name in this table, the cell in the next column will be populated with their company, based on the ...

16 апр. 2024 г. · The generated list needs to be vertical, and I need to be able to add new values to either list and have the generated list to auto-update ...

18 дек. 2023 г. · Trying to return the name from a long description. I have a list of names i'm referencing to pull from, and if it has the full name I figured out a formula.

7 авг. 2024 г. · I want to look at a cell, and if it matches something from a list, return that exact value from the list, not the entire contents of the cell.

2 февр. 2023 г. · A simple vlookup will do the trick. =VLOOKUP(lookup value = cell in column b, range = column A, 1,false) If the value from col b is not found in column a the ...

22 февр. 2023 г. · I need to write a formula to identify if any person in Column "Name" has the value Yes in Column "Eat" then the result should be all Yes for that Person.

26 июл. 2023 г. · Make the value of a cell change depending on which list option you pick. For example, if you choose the option "3 Personas" it shows the value "500" in another ...

13 авг. 2024 г. · I was wondering if it's possible to have this formula more simple, like to use a list with options for the "Value if true"? Also, if none of the ...