Data to pick from several sheets

[nagesh.tvsr]

Hi,

I need a formula in getting data from several sheets.

An excel file attached with necessary info.

Pl. help.

Thanks,
Nagesh.

[samba_ravi]

B4=INDEX(INDIRECT("'"&$A4&"'!$1:$1048576"),MATCH($A$2,INDIRECT("'"&$A4&"'!$a:$a"),0),COLUMN(B1))

Please Login or Register  to view this content.

Try this and copy across

[JohnTopley]

Try....

=IFERROR(VLOOKUP($A$2,INDIRECT( $A4 & "! A4:F4"),COLUMNS($A$1:B1),0),"")

BUT Need to rename "FAB A" as "FAB_A" and same for "FAB B"

[nagesh.tvsr]

Hi Siva, Thank you working well.

Hi John, not working .

Anyhow thank you the issue solved.

Thanks once again.

Nagesh.

[JohnTopley]

For completeness..

=IFERROR(VLOOKUP($A$2,INDIRECT( "'" & $A4 & "'! A4:F4"),COLUMNS($A$1:B1),0),"")

does wotk.

[nagesh.tvsr]

Yes John. Now working well.

Thank you too.

[JohnTopley]

Thank you for the feedback - appreciated.