combination vlookup & hlookup

[Kevinlzh]

Guys, I need urgent help with converting of the below raw data into the below format of data to be presented. I am open to all other methods, not necessarily using vlookup/hlookup.

Thank you.

(Raw data)

Fruit	Year	Price($)
Apple	2014	1.32
Apple	2016	1.49
Apple	2017	1.55
Pear	2013	1.48
Pear	2015	1.60
Pear	2017	1.29

<tbody>
</tbody>

(Format to be presented)

	2013	2014	2015	2016	2017
Apple	na	$1.32	na	$1.49	$1.55
Pear	$1.48	na	$1.60	na	$1.29

<tbody>
</tbody>

 

[njimack]

Assuming your raw data is in cells A1:C7 and your 2nd table is in A9:F11, enter the below (confirm with ctrl+shift+enter)
=INDEX($C$2:$C$7,MATCH($A10&B$9,$A$2:$A$7&$B$2:$B$7,0))

 

[Kevinlzh]

Assuming your raw data is in cells A1:C7 and your 2nd table is in A9:F11, enter the below (confirm with ctrl+shift+enter)
=INDEX($C$2:$C$7,MATCH($A10&B$9,$A$2:$A$7&$B$2:$B$7,0))

Wow you are a lifesaver! Thank you so so much!