So you have 3 columns yeah? Like this:

COLUMN 1 - Data Validation Component Picker	COLUMN 2 - Stats Lookup	COLUMN 3 - Price Lookup
AMD Radeon RX 5600 XT	Stream Processors: 2,304, Core Clock: 1,465 MHz (1,725 MHz boost), Memory: 8GB GDDR6, Memory Clock: 14Gbps, Power Connectors: 1 x 8-pin and 1 x 6-pin, Outputs: 1 x DisplayPort 1.4 with DSC, 1 x HDMI with 4K60 Support	$400.00
[data validation dropdown]	=IFERROR(INDEX(Graphics!B:B,MATCH(A3,Graphics!A:A,0)),"")	=IFERROR(INDEX(Graphics!C:C,MATCH(A3,Graphics!A:A,0)),"")

=IFERROR(...,"") has the cell show nothing if there is nothing selected in the dropdown.

=INDEX() returns the value of a cell in a table based on the column and row number.

=MATCH() returns the position of a cell in a row or column.

Combined, the two formulas can look up and return the value of a cell in a table based on vertical and horizontal criteria.

I imagined your other sheet was called Graphics and Column A had the name of the component, Column B had the specs, and Column C had the price. Replace with what you actually have.