Fill a table from data in another table

Hello
it all depends on the setup of your table
to look for a value A located in the 1st column of a range and return a value from the nth column on the same row:

=VLOOKUP(value A;range limits;column number to return;0)

the column number to return is the rank of the column in the range, not in the sheet

example:
returning from a range B1:X100, the value of column C on the row where value A is written in Z1 in column B:

=VLOOKUP(Z1;$B$1:$X$100;2;0)

if it is not in the 1st column:

=INDEX(range limits;MATCH(value A;search column;0);column range number to return)

example with the same range, but value to search in column D:

=INDEX($B$1:$X$100;MATCH(1;$D$1:$D$100;0);2)

to avoid error displays if value A does not exist in the column

from Excel 2007

=IFERROR(complete formula);"")

to be more precise, we would need to know more about your data

best regards

The quality of the response mainly depends on the clarity of the question, thank you!