Forum Discussion
DVMUK
Feb 03, 2025Copper Contributor
Stay calculator
Hi I am trying to make a calculator that works out the number of stay over nights required for an engineer. In the below screen shot of the spread sheet I have a 2 blue squares for data entry and t...
- Feb 04, 2025
For B6 cell you may use-
=INDEX(H2:L1000,MATCH(B4,G2:G1000,0),MATCH(B5,H1:L1,0))
Harun24HR
Feb 04, 2025Silver Contributor
For B6 cell you may use-
=INDEX(H2:L1000,MATCH(B4,G2:G1000,0),MATCH(B5,H1:L1,0))