• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I want to get the BKL number automatically when I put the INVOICE

Castieee

New Member
Can anyone help me I just wanna know the code to this. I want to get the BKL number automatically when I put the INVOICECapture.PNG
 

ETAF

Member
a sample spreadsheet would help give the code
is this VBA code or a formula

if a formula - have a look at index/match or vlookup -
but without a lot more info i cant help futher - whats a BKL number what cell is it in, where do you put the invoice - where to lookup the invoice number assuming it is a number
 

Castieee

New Member
a sample spreadsheet would help give the code
is this VBA code or a formula

if a formula - have a look at index/match or vlookup -
but without a lot more info i cant help futher - whats a BKL number what cell is it in, where do you put the invoice - where to lookup the invoice number assuming it is a number
I'm currently using 2019 excel, and the output i want is something like this1.PNG
 

ETAF

Member
i have added a lookup - that uses the Min and Max range in your table - so
=LOOKUP(2,1/((A12>=$E$12:$E$14)*(A12<=$F$12:$F$14)),$D$12:$D$14)

where
=LOOKUP(2,1/((value to lookup>=MinRange)*(value to lookup<=MaxRange)),results)

i have updated the dropbox link
 

Attachments

Top