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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
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

R
  • Question Question
Macro to add multiple identical rows of data from a workbook before or after each change in Column A
Replies
0
Views
188
rickadams
R
A
  • Solved
Filter formula based on drop down BUT with an option for all data
Replies
7
Views
303
myall_blues
myall_blues
L
  • Solved
Insert formulas to new lines in table
Replies
3
Views
154
Ltuk85
L
D
  • Question Question
If formula with date & VLOOKUP
Replies
1
Views
283
etaf
etaf
A
  • Solved
Missing Worksheet with Data Validation List Options
Replies
1
Views
145
ajm
A

Forum statistics

Threads
1,223,958
Messages
6,175,628
Members
452,661
Latest member
Nonhle

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