Vlookup of few levels

[lilahh]

Hello,

I eed to perform a search whithin a table in a few levels. For example:

Name Time Food preference
Dan Brekfest egg
Dan Lunch Meet
Dan Dinner Pasta
Ran Brekfest cheese
Ran Dinner meet
Simon Brekfest egg
Simon Lunch pasta
Simon Dinner pasta


I want to look the food prefernce for each one for different times. How do I do that?
Thank you,
Lilah

[AliGW]

Duplicate threads are not allowed. This thread is now closed. Continue in your other thread, please.