i am unable to use vlookup in numeric numbers stored as text - (2500 rows of
data)

=vlookup(a5,eg:gh,2,0)

col 1 col 2 col 3
1000372786741026 1000372786741026 $10

what formula is needed to lookup the number in column 2 and return the
information in col 3