data validation to extract records based on a cell value

I have a workbook with sheets cvt and currency listing .

Row A4 has header currency and column B4 represent the data validation list which the data is on sheet Currency listing .

My issue is how while entering value in B4 data validation list e.g EURO , IN CELL D4 and E4 it extracts the corresponding value to adjacent cell in column B and C

of currency listing through out data validation list

EUR E.E.C CURRENCY 1

Hi

Thank you exactly what I was looking for

will check your link as it is very interesting