Transfer Textbox to Sheet based on Value of 2 Other Textboxes

[rhombus4]

Hi

Trying to Transfer a Textbox to a Sheet based on its Value and the Value of 2 Other Textboxes (1 for Row and 2 for Column)

I have 3 Textboxes Textbox1 and Textbox2 and Textbox3

Textbox1 contains a Value to be Searched in Column D
Textbox2 Contains a Value which will be one of the Headings in Row 1
Textbox3 is the Value to be transferred

So If Textbox 1 is Cat and the Value in Textbox 2 is Colour and the Value in Textbox3 is Yellow
I want Yellow to go into G4 (G is where the Colour Heading is and 4 is the Row where Cat is

	A	B	C	D	E	F	G	H	I	J	K
1​				Animal	Country	Vegetable	Colour
2​				Aardvark	Angola	Apple	Amber
3​				Bear	Barbados	Banana	Blue
4​				Cat	Chile	Cherry	Cerise
5​				Dog	Denmark	Date	Dark Blue
6​				Elephant	England	Eggplant	Emerald Green
7​				Fox	France	Fig	Fuschia
8​				Goat	Greece	Grape	Gold
9​
10​

 

[GWteB]

You are welcome and thanks for letting me know.