View Single Post
  #7   Report Post  
Domenic
 
Posts: n/a
Default

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!