Problem with a cell displaying #N/A

SnipersLaww · March 12, 2025, 6:25pm

I have a cell located at B24 with the formula “=INDEX(RPM.B1:B1000,MATCH(‘Master Sheet’.C20,RPM.A1:A1000,0))”. C20 is the cell it should be pulling information from. C20 contains the formula “=IF(C8=”",P19,C8)" with C8 being a manually-input cell and P19 being an automatic value to be displayed if C8 happens to be empty. (C8 is essentially a manual override) B24 functions properly when C8 has a value but if C20 is getting its value from P19 (correctly showing an automatic value in P19) then B24 for some reason will display “#N/A”.

“Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded”

fpy · March 12, 2025, 6:41pm

Function Wizard

and Ask/Guide - How to use the Ask site - The Document Foundation Wiki #More_details

Wanderer · March 12, 2025, 6:55pm

From a screenshot only guesswork possible, but in this situation I’d check types (numeric vs string) first.
.
And you may follow the hint by @fpy and inspect the intermediate values using the function wizard.

SnipersLaww · March 12, 2025, 7:10pm

im not really that knowledgeable about the program so even pulling that up i wouldnt know how to use it properly. i have added the version information for the client i am using. i also have other cells that call upon C20 for its value and they work properly.