Vaucluse
Posted messages
27336
Registration date
Status
Contributeur
Last intervention
6 453
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!
