Vba function to compare a cell against two cells(range)

I have a very large database that contains transations and I want to compare bin numbers against a table to determine where the transaction resides from.

table one contains the order,

example bin 444445

against table w that contains over 10k varations of bins, High and low, and its corresponding country.

so you would compare 444445 against two cells to see if it fits in the range and then spit out the country for that line.

because of the number of records, it would need to proceed to next record once it find the matching range.

Evner: Microsoft Access, Visual Basic for Apps

Se mere: numbers function, number function, function of numbers, function numbers, function number, microsoft vba, find in vba, vba compare, transations, microsoft access vba, cells, access database transaction, vba function, function order, microsoft visual basic applications, vba range table, database vba, compare access database, compare access, range table, access database country, visual basic table cells, access table vba, microsoft access order database, visual basic table cell

Om arbejdsgiveren:
( 25 bedømmelser ) Oshawa, Canada

Projekt ID: #5996794

Tildelt til:


Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Flere

$29 USD in 0 dage
(19 bedømmelser)

3 freelancers are bidding on average $25 for this job


hi i can do this job, i have experience in VBA, i am confident with my skills that i can able to finish this task, thanks, tristan

$30 USD på 1 dag
(3 bedømmelser)

A proposal has not yet been provided

$17 USD på 1 dag
(0 bedømmelser)