How to get a value (equivalent vlookup in excel)

[transalp89]

I have a list of product. for each product I have a plan start  and the actual date for several process.

Depending some rules, I invoice the product at different stage of the process.

I want to create a table with the plan invoice date.

in joined excel sheet I putan example

sheet process with product/process and date for planned and actual

sheet Rules Product/ rule

sheet result is the wanted result.

I have try to use peek functiun without success

If you can help me it will be great !!

Thanks in advance !

[PradeepReddy]

see the attachment, it might be helpful...

[#3]

You can use Lookup function or ApplyMap method to achieve vlookup.