Forum Discussion

Brass Contributor

Jun 27, 2024

Cross Referencing Data in Excel

Hello, I have a spreadsheet that lists document numbers that are stored in a document management system. I have to cross reference the documents in that management system, which means I have to go ...

Document Tree.xlsx41 KB

excel

OliverScheurich

Gold Contributor

Apr 23, 2026

Hi,

the old formula still returns the expected results in my sample file. In the attached file i've added a formula for Excel 365 that spills the result.

Cross Referencing Data in Excel.xlsx31 KB

Sue_G

Brass Contributor

Apr 24, 2026

HI Oliver,

I don't understand what I'm doing wrong. This is odd as I've been using this file since you first created it for me and it's worked as expected. When I enter in a new number (either typing it directly or copy and paste), it does not give me an accurate list, even in the updated file for Excel 365 you attached, and in some cases, I get nothing listed in column C and a #CALC! error in column E under Documents returned by formula. Is it possible that I have a setting in Excel that would prevent this formula from working? Can you suggest what I might look at to see if this is the problem?

OliverScheurich
Gold Contributor
Apr 24, 2026
Hi Sue,
i've intentionally created a #CALC! error in my sheet. When hovering over the error message an explanation is shown (in german because i use german Excel). Could you attach a screenshot that shows the error message from your sheet?