View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default formula for if and v look up for 2 values

Donna ...

If you are using Filter Switches in Cols B & C ... & you Filter to a "size"
& "Material Type" what are you looking for a "vlookup" to do??? ... Thanks
.... Kha

"Tacklemom" wrote:

What I want is:
In Cell B2 you choose a size ( eg 1/2" ) from the drop down
In Cell C2 you choose a material either 304 or 316.

what I want is from B2 it will generate a vlook up for either 304 or 316
material depending on cell c2.... Not sure how to do this????
--
Donna