Thread: [Solved] How to use a Field as part of a Formula
View Single Post
 
Old 01-26-2024, 09:39 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
If I've properly understood what your looking to do, in D2, try:
Code:
=INDEX(Tabelle2!$C$3:$BE$27,MATCH(A2,Tabelle2!$B$3:$B$27),IFERROR(MATCH(B2,Tabelle2!$C$2:$BE$2),1))
copied down.
For the non-english version , open the attached.
Attached Files
File Type: xlsx msofficeforums51963Sample.xlsx (163.9 KB, 3 views)
Reply With Quote