Vlookup function (for loans prepayment repayment)

[wenhwei17]

Hi i have excel with loan repayment and prepayment. As u can see on L18 (5 Dec 2016) i have both repay and prepay but when i put the formula it does not comes out the prepay because i of my table of array reads only first date as repay. Can anyone help me please thanks

 

[awoohaw]

@wenhwei17
Can you repost the data/worksheet potion using the xl2bb add in (link below) or as a table (identifying row and columns and pasting formulas in your text).
The image above is too small to reasonably read.

Thanks in advance,
Best Wishes

 

[wenhwei17]

@wenhwei17
Can you repost the data/worksheet potion using the xl2bb add in (link below) or as a table (identifying row and columns and pasting formulas in your text).
The image above is too small to reasonably read.

Thanks in advance,
Best Wishes

Hi is this ok

Thanks

 

[Fluff]

Can you post some actual data, rather than an image.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[wenhwei17]

Can you post some actual data, rather than an image.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Thanks so much will test it out and repost much thanks