In article ,
"Watercolor artist"
wrote:
What if the lookup price was in Column C rather than B and that I wanted to
ignore what's in B?
=VLOOKUP(A2,'C:\[Pricing.xls]Sheet1'!A:C,3,FALSE)*B2
Also, in "A:B,2,FALSE," what exactly do those parameters mean?
Have a look at the help menu for a detailed explanation.
Hope this helps!
|