I would like to request all of your help.
I have tried a few formulas like vlookup, If and others within my little knowledge . But, can't . Tried to google and youtube, not exactly found also.
Attached is sample file.
Eg. I key in data in Invoice Details sheet , then want to show automatically in Invoice Format Sheet ..
If invoice no is 1 , then auto show product name , price, qty in invoice format .
Usually, one invoice got a few 4-5 products contained. Lookup invoice no, then return multiple results .
Someone ,can help me please?. Thanks in advance
Bookmarks