Hi,
I need a formula in getting data from several sheets.
An excel file attached with necessary info.
Pl. help.
Thanks,
Nagesh.
Hi,
I need a formula in getting data from several sheets.
An excel file attached with necessary info.
Pl. help.
Thanks,
Nagesh.
B4=INDEX(INDIRECT("'"&$A4&"'!$1:$1048576"),MATCH($A$2,INDIRECT("'"&$A4&"'!$a:$a"),0),COLUMN(B1))Try this and copy acrossPlease Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
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"
Hi Siva, Thank you working well.
Hi John, not working .
Anyhow thank you the issue solved.
Thanks once again.
Nagesh.
For completeness..
=IFERROR(VLOOKUP($A$2,INDIRECT( "'" & $A4 & "'! A4:F4"),COLUMNS($A$1:B1),0),"")
does wotk.
Yes John. Now working well.
Thank you too.
Thank you for the feedback - appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks