On Thursday, 10 December 2020 at 06:55:17 UTC+2, Norbert wrote:
On Wednesday, 9 December 2020 at 18:48:40 UTC+2, Claus Busch wrote:
Hi Norbert,
Am Wed, 9 Dec 2020 06:39:41 -0800 (PST) schrieb Norbert:

If I understand it correctly, Index specifies a cell (by the number for row and column of a certain array)
Ok, the column we don't have, therfore we need the "match" function. The row is actually the 371st row of the range, but
in the Excel spreadsheet it is row no. 376, therefore I think I have to change both 376 to 371.
I tried that, still #N/A

I tried to only find the column number by entering: =Match(D8,WEEKLY_DATABASE,0)+1
Result: #N/A

The content of D8 is actually a formula which returns a name of a person (text)
D8: =VLOOKUP(D7,P8:R59,2,FALSE)

The names are listet in array WEEKLY_DATABASE in its first row (row no.6).
I don't understand your layout. How can you find a value in C376 if
WEEKLY_DATABASE is in range ("E6:FA505")?
Can you provide the workbook?
Regards
Claus B.
--
Windows10
Office 2016
Good morning Claus,
I sent you my file yesterday evening but this morning I see it could not be delivered. I used your t-online.de address.
I will try again, now.
Regards, Norbert
Sorry Claus, emails are all coming back. I didn't even attached a file, just a dropbox transfer link.