Thanks to both of you
Post marked SOLVED
Rep added
Thanks to both of you
Post marked SOLVED
Rep added
Last edited by rehana402003; 12-19-2019 at 10:00 AM.
Your expected answer in F10 is incorrect, I think...
VLOOKUP(E7,Sheet2!A:C,3,FALSE)*MIN(2,D7)+VLOOKUP(E7,Sheet2!A:B,2,FALSE)*(MAX(0,D7-2))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Try this
=VLOOKUP(E7,Sheet2!$A$2:$D$8,3,FALSE)*MIN(D7,2)+VLOOKUP(Sheet1!E7,Sheet2!$A$2:$D$8,2,FALSE)*(D7-MIN(D7,2))
Dear Glenn
Yes you are right
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks