Snapshot VLOOKUP Help

I need to know if VLOOKUPS are able to put and calculate data for a snapshot report. Please see the attached spreadsheet along with requirements. Appreciate the help.

Hi,

In your PDF you refer to 6 snapshots but there are only 5.
Am I missing something?

Regards

peterrc

Sorry i meant 5.

Hi,

In your snapshot(s) you show:-

DAP under Incoterm - but DAP isn't shown in the Data under Incoterm
Express under Service but - Express isn't shown in the Data under Service
March under Month - but March isn't shown in the Data under Month (columns G, K and P)

Can you clarify please?

Regards

peterrc

These have not been selected yet but may be added in the future when people add new lines and use the drop down box

Screenshot_1.jpg

Hi
Try this approach
Use in Snapshot!B3 the following formula

Formula:

Please Login or Register  to view this content.

where your row 1 from column B has the following values 2, 20, 22, 24, 26
This values can be founded if the labels of column match the labels of you data using MATCH function.
See the file

Hi,

It is possible that I have misinterpreted your requirements.
The Pivot Table I have attached only shows the data that relates to the Shipping Company selected in cell C20.

Regards

peterrc