Hi, is it possible to combine vlookup with get value in specific row. Do i need to do macro behind or it can be done with cell formula only. When using vlookup only value in first row retrieve.Example as
=VLOOKUP(B4,B3:C9,2,FALSE)
In scenario below, i want to get payment date result based on...