Hi gents,
I am trying to find the correct syntax/formula for getting a value from a table based on a value from another cell in an other sheet.
Eg this is the table
In my other sheet I have
61427 but a few cells lower i want to get the second value from the tabel "6152"
so in cel A1 I have =A10 and I want to get the below value from A11
hope that makes sence
I am trying to find the correct syntax/formula for getting a value from a table based on a value from another cell in an other sheet.
Eg this is the table
In my other sheet I have
61427 but a few cells lower i want to get the second value from the tabel "6152"
so in cel A1 I have =A10 and I want to get the below value from A11
hope that makes sence