VLookup Or Other To Match Data.

fintail99

New Member
Joined
Apr 4, 2017
Messages
36
Hello again!

The formula above does what we require it to do, but obviously shows #N/A until a time is entered. Is it possible for the resultant cell with monetary value to remain blank until start & end times are entered?

Thank you,
Ketan
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
44,466
Office Version
365
Platform
Windows
How about
Excel Formula:
=IF(AND(C2<>"",D2<>""),INDEX(Sheet1!$B$2:$J$7,MATCH(A2,Sheet1!$A$2:$A$7,0),MATCH(ROUND(E2*60,0),Sheet1!$B$1:$I$1,0)),"")
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,855
Messages
5,507,725
Members
408,647
Latest member
Nicho la zido

This Week's Hot Topics

Top