View Single Post
  #8   Report Post  
Watercolor artist
 
Posts: n/a
Default

By Help Menu, do you mean the F1 help in Excel? If so, that didn't answer the
questions I'm now asking.

"Domenic" wrote:

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!