Amount to find for Vehicle numbers.

[Shabbo]

Dear Sir,

Please find attached herewith my excel sheet in want formula like

1) My Bank sheet has my data with date and vehicle numbers

2) My advance sheet has vehicle number and date as well I wanted to lookup my advance sheet amount in J column from bank paid amount from F column of bank sheet.

 

[Thangavel]

Dear Sir,

Please find attached herewith my excel sheet in want formula like

1) My Bank sheet has my data with date and vehicle numbers

2) My advance sheet has vehicle number and date as well I wanted to lookup my advance sheet amount in J column from bank paid amount from F column of bank sheet.

Hello,
You can use Index/Match formula.

=IFERROR(INDEX(Bank!F:F,MATCH("*"&Advance!K3&"*",Bank!G:G,0)),"")

Please refer the attached excel for more clarity.