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

[Castieee]

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

 

[ETAF]

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]

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 this

 

[ETAF]

how about
=INDEX($D$2:$D$6,MATCH(A2,$E$2:$E$6,1))

Dropbox - File Deleted - Simplify your life

www.dropbox.com

 

[Castieee]

how about
=INDEX($D$2:$D$6,MATCH(A2,$E$2:$E$6,1))

Dropbox - File Deleted - Simplify your life

www.dropbox.com

This is what i was looking for, THANK YOU SO MUCH!

 

[ETAF]

you are welcome
Note - I remove the dropbox file after a few days

 

[ETAF]

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