About 1,145,787 results (1,035 milliseconds)
Compare cell on sheet2 to cells in column on sheet1 and return ...
https://support.google.com/docs/thread/5083754/compare-cell-on-sheet2-to-cells-in-column-on-sheet1-and-return-value-of-adjacent-cell?hl=en Apr 28, 2019 ... I want to compare a value to a column, find the matching value in said column and output the value of the cell left of the matching value cell.
Formula to return if cell is blank (no visible text) vs contains formula ...
https://support.google.com/docs/thread/168620875/formula-to-return-if-cell-is-blank-no-visible-text-vs-contains-formula-value?hl=en Jun 24, 2022 ... I am trying to use a simple function to return one value if true and another if false. I have a few columns, all containing a formula.
Quick Question - Is it possible to simply return the current cell value ...
https://groups.google.com/g/exceldna/c/up5dq21mfjE Jan 21, 2016 ... ... returns 0 no matter what the value in the cell is before the call: ExcelReference caller = XlCall.Excel(XlCall.xlfCaller) as ExcelReference;.
Google Sheet - Find a value and return value in cell directly below ...
https://support.google.com/docs/thread/171626335/google-sheet-find-a-value-and-return-value-in-cell-directly-below?hl=en Jul 18, 2022 ... I want to be able on the Weekly sheet in the third column to lookup the date that is in column A for that row and search the Monthly sheet for that date.
IF function returns #VALUE! if the search value is not found - Google ...
https://support.google.com/docs/thread/224524415/if-function-returns-value-if-the-search-value-is-not-found?hl=en Jul 7, 2023 ... I have placed a possible solution for you in the sheet/tab called Help in cell X2, which I have added to your file. This one formula will give ...
Return a value based on another cell - Google Docs Editors ...
https://support.google.com/docs/thread/270024366/return-a-value-based-on-another-cell?hl=en Apr 18, 2024 ... I need to return a numeric value, depending on the value is in another cell. For example, if C3 is 1 than D3 would be 50, if C3 is 2 than D3 would be 45, if C3 ...
Skip excecution of UDF but keep old cell values
https://groups.google.com/g/exceldna/c/a4WjSeqsYLo Mar 29, 2017 ... Excel does not have a way for a UDF to abandon the calculation, and not return a value. Your UDF can read the old value of the cell, but that ...
Find highlighted cell in a range and return the contents of the ...
https://support.google.com/docs/thread/100804068/find-highlighted-cell-in-a-range-and-return-the-contents-of-the-highlighted-cell-to-another-cell?hl=en Mar 4, 2021 ... I am trying to find the formula/function that would search for the yellow highlighted cell in the row and return the value or combination that is in the cell ...
Return value in specific cell based on values for row and column ...
https://support.google.com/docs/thread/266565779/return-value-in-specific-cell-based-on-values-for-row-and-column-headings?hl=en Mar 29, 2024 ... I have a sheet with a table that contains pay rates based on two factors, years of employment and pay level. I need a formula that can reference this table.
How do I ask a cell to return a value from another cell if another cell ...
https://support.google.com/docs/thread/156398958/how-do-i-ask-a-cell-to-return-a-value-from-another-cell-if-another-cell-contains-certain-text?hl=en Mar 22, 2022 ... I've created a spreadsheet of English premier league football (soccer) teams and am trying to work out how I can get a cell to fill in a value based on the the ...
Lookup and Vlookup return results if value isn't found. I need to ...
https://support.google.com/docs/thread/46261703/lookup-and-vlookup-return-results-if-value-isn-t-found-i-need-to-show-an-error?hl=en May 12, 2020 ... I'm trying to create a lookup function that gives an error or a problem in a cell when the value is not found in the array I'm searching.
openpyxl returns None for value actually present and updated in the ...
https://groups.google.com/g/openpyxl-users/c/GbBOnOa8g7Y May 24, 2017 ... However, i found an issue regarding the data read by openpyxl upon saving the file with formulas. After updating the cell value and saving , ...
How to reference cells value and not it's formula - Google Docs ...
https://support.google.com/docs/thread/6274141/how-to-reference-cells-value-and-not-it-s-formula?hl=en May 16, 2019 ... ... get the 13 in that last picture. LEFT will return text instead of numbers and might include some non-graphic elements. Since your comparison ...
Matching 2 columns and returning value from 3rd column - Google ...
https://support.google.com/docs/thread/3989016/matching-2-columns-and-returning-value-from-3rd-column?hl=en Apr 11, 2019 ... I need help with a formula that can look at all the cells of column D, find out the matching cells in column A, and then return the relevant ID-number to ...
If cell a matches a value from a range of cells, return cell b in cell c ...
https://support.google.com/docs/thread/304855813/if-cell-a-matches-a-value-from-a-range-of-cells-return-cell-b-in-cell-c?hl=en Oct 30, 2024 ... I want cell I20 on my Budget Dashboard to tell me the sum of my Rent transactions in the month selected from the dropdown menu.
ExcelReference.GetValue() throws XlCallException
https://groups.google.com/g/exceldna/c/xm8DZ5Eld9E I need to close Excel entirely. Do you have any clues on to how to attack this issue? If I want to return the value of a specific cell within the range ...
Query Formula return error #VALUE when cell is text - Google Docs ...
https://support.google.com/docs/thread/34107494/query-formula-return-error-value-when-cell-is-text?hl=en Mar 18, 2020 ... I am wondering what is wrong with this formula because when the cell L44 is in number (Eg: 12345) it was able to return the query.
Return value of column b or c, based on column a - Google Docs ...
https://support.google.com/docs/thread/265690916/return-value-of-column-b-or-c-based-on-column-a?hl=en Mar 25, 2024 ... In this case, the formula lives in cell E1 only. What is important is that cell E1 and cell F1 and cell E2 and cell F2 must be cleared before ...
Why can't I use the results of an array formula in another cell's ...
https://support.google.com/docs/thread/6075288/why-can-t-i-use-the-results-of-an-array-formula-in-another-cell-s-countif-formula?hl=en May 13, 2019 ... ... cells returning values from the array formula in rows 5+. Thank you ... Matt posits the you're using a port from Excel, or using your old Excel ...
SHEETS: How to reference the Text/Value from one cell within a ...
https://support.google.com/docs/thread/137041108/sheets-how-to-reference-the-text-value-from-one-cell-within-a-formula-of-another-cell?hl=en Nov 24, 2021 ... ... cell into a formula? For example: =(Value of A12)!B24 to return the value of B24 from with a sheet named after the value of A12. In my PHP ...