VLookup Across Multiple Tables By Condition

Vlookup across multiple tables by condition
I use Office 2003
I want a solution by the formulas

Explain what you want the formula to do? Just uploading a file and expecting the volunteers to figure out what you want is not a good way to ask for help.

Explanation inside the file
Thank you Mister (excel fox)

up

up

Hi,

With the formulas, a multiple-range ..
An example

Very, very wonderful solution
Thank you very much