how to get data from all 4 sheets???

Status
Not open for further replies.
I

INKLO708

Banned user
Joined
Aug 15, 2020
Messages
21
Office Version
  1. 2016
Platform
  1. Windows
how to get data from 4 sheets in another 5th sheet.
right now i am getting data from 1 sheet as this formula =IFERROR(INDEX(PAINT!$E$7:$J$406,PAINT!$D128,COLUMNS($B$16:F137)), " ")
but how to get data from all 4 sheets???
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
when entering the formula just click on the cells you want to reference on the other sheets. pretty sure excel will generate the correct references to the other sheets automatically
 
Upvote 0
INDEXING ISSUE ACTUALLY.....EVERY SHEETS HAS DATA BASED ON ROWS AND COLUMNS DATA. its not a cell thats y asking.???
 
Upvote 0
Duplicate to Index Multiple Sheets

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.
 
Upvote 0
Status
Not open for further replies.

Similar threads

E
  • Question
Formula to look at Column G&H in groups of data & returns the number repeated the most in each group.
Replies
4
Views
123
Event2020
E
E
  • Question
Dynamic small function
Replies
1
Views
218
KRice
K
A
  • Solved
Adding a Second Condition to a Return List Array Formula
Replies
8
Views
153
Fluff
Fluff
K
  • Solved
My VBA is only copying the last row of data instead of all the rows
2 3
Replies
24
Views
570
Alex Blakenburg
A
J
  • Question
Formula to move information to calendar
Replies
0
Views
104
jc352
J

Forum statistics

Threads
1,215,426
Messages
6,124,828
Members
449,190
Latest member
rscraig11

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top