VLOOKUP question
 

In =VLOOKUP(A2,'C:\[Pricing.xls]Sheet1'!A:C,3,FALSE)*B2, what does
"A:C,3,FALSE" mean?

The False means that an exact match must be made between the lookup value
(A2) and the lookup range an error will be the result if there is no match.
advantages of this are that when you must have an exact match you can force
it. also the lookup table does not have to be sorted before it works.

"Watercolor artist" wrote:

In =VLOOKUP(A2,'C:\[Pricing.xls]Sheet1'!A:C,3,FALSE)*B2, what does
"A:C,3,FALSE" mean?