Thread: Index, match, or hlookup ~ which function to use @_@
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PJS PJS is offline
external usenet poster
  
Posts: 23
Default Index, match, or hlookup ~ which function to use @_@
Hi ^_^

I was wondering how to achieve this. Any help or input would be great.
Thank you.

Sheet1 ~ data source
Type/Value
A 1 2 3
B 2 4 6
C 1 3 6

Sheet2
1 2 3 4 5 6
A Y Y Y
B Y Y Y
C Y Y Y
Reply With QuoteReply With Quote