fromula to get data from multiple sheets

G

GAK

I want to get the data in my final worksheet from multiple worksheets
depending upon the condition that i give is found true fro example i used
vlookup(A1,ABC,1,false) where cell A1 contains the value which I am searching
and "ABC" is the name of range in multiple worksheets, as(
Sheet1:Sheet10'!B:J) has been define as name "ABC"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top