Thread: For Each Cell in Sheet1 Range, do some Vlookup calc. from Sheet3
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default For Each Cell in Sheet1 Range, do some Vlookup calc. from Sheet3
The solution looks easy to me, and doesn't require VBA. Merely enter
formulas on Sheet2 that use values from Sheet1 and Sheet3, e.g. for
Sheet2, cell B2: =Sheet1!B2*Sheet3!B2

Hth,
Merjet

Reply With QuoteReply With Quote