View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PaulaB PaulaB is offline
external usenet poster
 
Posts: 9
Default double or nested vlookup

Is there a way to look up not just one value, but two, in order to give an
output?
For example, column A has values A through D, repeated 5 times, and column B
has 1 through 10 repeated twice. Column C is the output value. How to I get
another worksheet to give me the value from C and 5 since Vlookup will only
find either C or 5?
--
Thanks,
Paula