I'm currently using 2019 excel, and the output i want is something like thisa 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
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