Showing a cell value of a cell in a cell in another location.

[Anuru]

Dear Experts,

Pls find the attached excel sheet which has been developed for machine break down monitoring of a garment factory.

Details:

Here in this sheet, column "C" contains the line nos where the machine break down took place. column "F" includes the "serial no" of the broken down machine.


Columns AG,AJ, AM etc shows the list of the total number of machines(serially) available in the factory. Columns AI, AL, AO etc shows the repair time related to that particular machine based on the repairing time calculated in column "c".


My requirement is to get the line no of the repaired machine in to column AH based on the machine number details in the column F. Here in the F column, the same machine serial no can be repeated several time depending on the number of times that particular machine breaks down.

It doesn't matter how many times a particular machine break downs, but I need to see the "line No" where that machine is operating by referring to column AH, AK and AN etc.

Thanks and regards
Anuruddha

[vlady]

maybe
=INDEX(C:C,MATCH(AG5,F:F,0))

[Anuru]

Dear Vldy,

It worked, thanks for you kindness. God bless you.

b/regards
Anuruddha