Vlookup Formula

[ceblaser]

I am having a problem creating a formula. Here is what I want to do:

Let's say I have the following information

Acct # Name Amt
123 Joe $5.00
456 Ann $4.00
123 Joe $2.00

I want to insert a vlookup formula that will go and find the account
number and pull in the amount. However, I do not want it pulling in
the same $5.00 for Joe each time. Instead, the second time it looks
for account # 123 I want it to pull in the $2.00 amount.

So is there a way to create a vlookup formula that will pull over the
amount after it has checked to see if that account number and amount
have already been pulled. If it has, it will then look for the next
account number match and pull that amount over?

Thanks!!!

 

[Don Guillett]

Look at a macro using find. You will "find" a great example in the visual
basic editor HELP index for FIND.

 

[Peo Sjoblom]

You could do this with a combination of index and small and get second third
occurrence but
it is fairly complicated and I'd suggest you use autofilter and filter on
account and name and
the just copy and paste the amounts