Entry to find

[Shabbo]

Dear Sir,

I wanted to get entry no I in Bank Sheet Column “O” on the basis of Vehicle number and Column P that is trn_dt4.


Eg : if Vehicle number in Column F is MH08 HS 6665 and trn_dt4 is 01/10/2017 then entry number will come from Datasheet that is Y171803678.

 

[Mr.Lobão]

Shaboo, Good afternoon.

It's not clear for me what exactly you want.

But.....Try to use:

TAB: BANK

O2 -->formula -->

=INDEX(Datasheet!$A$2:$A$1000, SUMPRODUCT((Datasheet!$I$2:$I$1000=F2)*(Datasheet!$B$2:$B$1000=P2)*ROW(Datasheet!$A$2:$A$1000))-1)

Is that what you're looking for?
I hope it helps.

P.s.:
I'm sorry! I tried to upload a new file as you did on your message but I recieved an error message all 3 times when I try to do it.

 

[Khalid NGO]

Hi,

Please try this:

=INDEX(Datasheet!$A$2:$A$7,MATCH(F2&"|"&P2,INDEX(Datasheet!$I$2:$I$7&"|"&Datasheet!$B$2:$B$7,),0))

Regards,