Auto tab- Auto fill
 

I'm looking for a general formula for the entire worksheet. My secretary
spends extra time looking for the proper column each time she subsequently
enters a vendors name .
Is there some formula that would recognize the second (third, fourth, etc)
time a vendors name is entered and auto tab to the column that was last used
for that vendor? Also, the same for many different vendors on the same page.

Same question a different way: if the vendor's name were entered a second
time and a different amount were entered could that amount be auto filled in
the column that was used previously on the same worksheeet? Regards