Short key for data entry

[Shabbo]

Dear Sir,
Can we make a formula like
Sheet2 Column C5 has complete Invoice number like M1920-0001
Sheet1 Column B3 if put just 0001 then in the same column complete invoice number like M1920-0001 will come.

 

[Chihiro]

What you'd need is to set up dynamic data validation (searchable).

See link for set up using iterative calculation without VBA.
https://chandoo.org/forum/threads/searchable-drop-down-without-vba.38037/