#ref error

Hello, I am pulling my hair out as I cannot see the issue with this formula: =INDEX(CombinedNOI[OBJECTID],MATCH(MIN(SQRT((CombinedNOI[Lat]-U13)^2+(CombinedNOI[Long]-V13)^2)),SQRT((CombinedNOI[Lat]-U13)^2+(CombinedNOI[Long]-V13)^2),0),1) It was working perfectly until I linked it to a...

Hello I tried to use this code to copy all the data from the column P6:P (last line) from the sheet "Original" and paste it on another sheet called "Test", well actually those data from the sheet "Original" are values, which are sums values by using FormulaR1C1. When I copy that on the sheet...

So... basicly what the title says. I have a formula which lets me filter values from a huge table as a database. the formula is as follows: =LET(Advanced, IFS(F2<>"",SEARCH(F2,'Verbrauchsmaterialien Datenbank (work in...

Hello, I'm back again, let me just say that I found this website to be very helpful. I currently have a script that was created by an external source. I don't have access to that person anymore. When I try running the script its returning a 1004 error (see attachment). From what i can see...

basically I have easy to read and modify values on sheet 1. Then on sheet 2 I have references to sheet1 (=sheet1!A1) in proper arrangement, with additional formatting mixed in. The problem is obvious when someone inserts, cuts, or deletes rows, on sheet1 you get a #ref error in sheet 2. I...

I have two workbooks: A & B In workbook A worksheet 1, cell A1 has a date. I input it as: mm/dd/yyyy, but it visually shows as: Month Year. Example: Inputting 04/01/2019 will visually show as: April 2019. In workbook B, I have multiple worksheets. Each sheet is labeled after a Month and Year...

Greetings: First time on this forum. I'm glad this is here. Using 2003 on Windows 7 (I know, both are way behind the times, but they work for me!) I need to find a way to locate the source of a #REF error. Until now I've always been able to scan my columns and find the cell with #REF right...

Hey all I need some genius, I've been trying to find a way to swap an exception price with a generic item price for specific customers. I have two large databases, one with item codes/descriptions/prices (CC8-3465, CC16- 3324, MSO2-1456, etc.), and one with customers (1002 - Customer 1, 3244 -...