Indirect & Match

[CarlW1179]

Hi
I am trying (and failing) to pull specific data from 1 sheet "LOG" to a "Request Form" using a sequential number as the guide reference and when the sequential number is changed on the Request Form all the date is entered from the corresponding row in the Log.


The data will be inputted into the log

and transferred over to the corresponding green highlighted sheets

I have been pinning my hopes on this formula but it just isn't working

=INDIRECT("'Disposal Log'!"),(MATCH(B2,'Disposal Log'!B:B,0),MATCH(A3,'Disposal Log'!2:2,0),4))

Any help would be appreciated.

 

[CarlW1179]

That suggests that you have a mix of text & numbers (where the numbers are formatted to show leading zeros), they all need to be the same.

Hi

Thats got it.

Thank you so much for your help your a star.

 

[kvsrinivasamurthy]

In B3

=INDEX('Disposal Log'!$C$3:$L$10,MATCH($B$2,'Disposal Log'!$B$3:$B$10,0),MATCH(A3,'Disposal Log'!$C$2:$L$2,0))

Copy to B4, D4, F4.
In M4

=INDEX('Disposal Log'!$C$3:$L$10,MATCH($B$2,'Disposal Log'!$B$3:$B$10,0),MATCH(K4,'Disposal Log'!$C$2:$L$2,0))

Similarly change the value (K4) and use for other cells.

 

[Fluff]

You're welcome & thanks for the feedback.