Forum Discussion

johanvl's avatar
johanvl
Copper Contributor
Nov 12, 2023

lookup data

Hello,   trying to make this work: In sheet A, i have   Column A: Start Date  Column B: End Date  Column C: Article A costprice  Column 😧 Article B costprice  Column E - T: Article C to Arti...
excel
Formulas and Functions
rachel's avatar
rachel
Steel Contributor
Nov 12, 2023

johanvl 

 

Hi,

 

Instead of nested ifs, I think you can use INDEX and MATCH functions to achieve this:. (example attached)