get cell value if vlookup returns a specific data

Hi

And how, exactly, is that supposed to refer to what you originally posted??
There is no similarity between this formula and the information you posted on Sheet Test.xls