VLOOKUPS and changing column headings

E

enuff2bdangerous

New Member
Joined
Oct 7, 2003
Messages
7
Need help with a project. Currently I have a Status Report that has to be updated daily with the same type information, inventory ,WIP , Shipments etc.

All of this data is available from Access tables from night runs off our ERP system, so the data and its format is consistent from day to day.

Normally I would simply use VLOOKUP to populate the report data from Pivot Tables of the Access data. The problem here is that though the part number data is pretty much statis the inventory locations can change from day to day making the column argument in a VLOOKUP worthless.

Is there a way to lookup the part number and then match to a specific column heading ,and then return the value in the intersecting cell ?
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
Sounds like you might want to try an =Index(Match(),Match()) type approach. You might set up a small test table and use the Lookup Wizard (Tools | Lookup...) and play around a bit. That can teach you some basics. If you get stuck or if that looks like it's not going to fill the bill for you, post back, preferably with some sample data (COLO's utility works quite nicely for that) and someone around here will help you along.

HTH
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Map column headings to Row value based in value in Row/Column Cell
Replies
6
Views
241
Alex Blakenburg
A
Data123
  • Solved
MSFT 365 Price Change For X Number Of Days
2
Replies
13
Views
336
awoohaw
awoohaw
T
  • Solved
Finding and moving data between worksheets based on dynamic variables
2
Replies
13
Views
802
OaklandJim
O
S
  • Question
Fix Column Reference? Changes with External Data Refresh
Replies
1
Views
65
Scotster
S
O
  • Question
Count only one occurrence of all criteria being met
Replies
8
Views
548
KRice
K

Forum statistics

Threads
1,215,865
Messages
6,127,400
Members
449,382
Latest member
DonnaRisso

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