Forum Discussion

learner1234's avatar
learner1234
Copper Contributor
May 02, 2021
Solved

XVERWEIS konvertieren für Excel 2013

BS?A19 06.05.2020 13.05.2020 20.05.2020 20.05.2020 BS1A19   BS1A19 B1=XVERWEIS(A1;B2:D2;B1:D1;"-";2;-1) = 20.05.2020   Hallo, ich möchte o.g. XVERWEIS für Excel 2013 konvertieren I...
excel
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 02, 2021

learner1234 Try this one:

=INDEX(A1:D1,1,MAX((B2:D2=HLOOKUP(A1,B2:D2,1,FALSE))*COLUMN(B2:D2)))

=INDEX(A1:D1;1;MAX((B2:D2=WVERWEIS(A1;B2:D2;1;FALSCH))*SPALTE(B2:D2)))

Entry needs to be confirmed with Ctrl-Shift-Enter (CSE) which will put curly brackets around the formula. Tested it on Excel2013 and it worked. File attached for your reference. The formula should come across in German automatically.

 

Resources