Blog

What’s the correct answer to the following statement:

You have a list of invoice numbers & amounts in a range A1:B100.

Some of the invoice numbers are duplicated.

You wrote VLOOKUP to find the amount corresponding to an invoice number.

If that invoice has 2 entries, then VLOOKUP will…