You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

- Thread starter Castieee
- Start date

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

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

how about

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

###
Dropbox - File Deleted - Simplify your life

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

www.dropbox.com

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

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

## Dropbox - File Deleted - Simplify your life

www.dropbox.com

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

=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