View Single Post
  #1   Report Post  
prakash
 
Posts: n/a
Default I want to use Vlookup function and AND function in a single formu.

We have created excel spreadsheet. In one column we have description of the
activity , 2nd column has activitiy ranges. We have to build an VLOOKUP
formula to check the description of the activity and check the activity
ranges in the 2nd column and than give us the correct value in a particular
column (Correct values are in 4th column). Request help on the same to build
a formula using VLOOKUP AND functions.