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.

 

[Fluff]

For B4 try

=XLOOKUP(B2,'Disposal Log'!$B$3:$B$1000,'Disposal Log'!$D$3:$D$1000)

 

[CarlW1179]

For B4 try

=XLOOKUP(B2,'Disposal Log'!$B$3:$B$1000,'Disposal Log'!$D$3:$D$1000)

Hi
thanks for that however its returning #NAME?

 

[Fluff]

Are you using 365 as per your profile?

 

[CarlW1179]

Are you using 365 as per your profile?

Hi
Running Office home and business 2019

 

[Fluff]

Then why does your profile show 365?

Try

=INDEX('Disposal Log'!$D$3:$D$1000,MATCH(B2,'Disposal Log'!$B$3:$B$1000,0))

 

[CarlW1179]

Then why does your profile show 365?

Try

=INDEX('Disposal Log'!$D$3:$D$1000,MATCH(B2,'Disposal Log'!$B$3:$B$1000,0))

Hi
I run 365 on my personal account however I'm doing this through work and they run 2019. Ill specify next time to stop any confusion.

 

[Fluff]

Ok, did the new formula work?

 

[CarlW1179]

Ok, did the new formula work?

Sorry got called away for a sec. No its returning #N/A

 

[Fluff]

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.