Hello all
Can you please help me write a formula in column C ( Value) of the worksheet to return the Value corresponding to the Name (column B) in the tab matching column A.
I have highlighted the row in respective tabs for clarity.
Second request is to do a vlookup in each account tab( as I have given as example in IBM tab) with the table in Worksheet and return Name values if the tab name matches the account and Name matches the name.
Many Thanks
Try,
In "Worksheet" C2, formula copied down :
=VLOOKUP([@[Name (provided)]],INDIRECT("'"&[@[Account (provided)]]&"'!A:B"),2,0)
Lemon squeezy - Thanks a ton.
can you think of how to do the second part please - Second request is to do a vlookup in each account tab( as I have given as example in IBM tab) with the table in Worksheet and return Name values if the tab name matches the account and Name matches the name.
In each Sheet of ,"IBM", "Accenture"…... C2, formula copied down :
=IF(SUMIFS(Worksheet!$C:$C,Worksheet!$A:$A,MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,32),Worksheet!$B:$B,[@Name])=[@Value],[@Name],"N/A")
Thanks a ton. Could you spare a few mins to explain the above formula to me ? esp this part : MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,32)
This part : MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,32)
will return the current sheet name.
Don’t have an account yet? Register yourself now and be a part of our community!
