Forum

Notifications
Clear all

Lookup data across multiple sheets?

3 Posts
3 Users
0 Reactions
71 Views
(@Anonymous)
Posts: 0
New Member Guest
 
I like the way you explain. You great knowledge about. I need you help.
 
To summarizes data of Sku select one sku, will display unit weight, change qty of the item say 1,2,3or4 ..unit this will give the total weight of the item(s). Which is rounded to number.
 
I have origin zip code to Destination zip to get zone. Once total weight (max 150 lbs/68 kgs)is figured out and zone then it needs to go and check row for corresponding and corresponding column different service type (Priority/Standard/2Day/Ground).and display on first page.
 
I have one example of heading and sku with I need to pull from other tabs and display in first page. SKU:12545470 / Description:E Product item / Unit Shipping Weight (lbs):1.6 / how many max150 lbs/68 kgs:1 / total weight max150 lbs/68 kgs:1.6 / Total Weight Round off (=CEILING(J#,1)):2 Origin Zip :98101 /Destination Zip :12508 / Destination State:NY / Zone:8 . Priority Tab Cost:37.51 / Standard Tab Cost:34.17 / 2Day Cost:17.14 / Ground Cost:8.70
 
Please advise you are able to teach me how I can do this. I will really appreciate your help.
 
Posted : 20/11/2020 6:24 am
(@wilkies0106awhotmail-com)
Posts: 19
Eminent Member
 

Hi,

Can you attach an example.
Which version of Excel are you using?

A

 
Posted : 20/11/2020 8:04 am
Anders Sehlstedt
(@sehlsan)
Posts: 970
Prominent Member
 

Hello,

As Andrew mentions, providing a sample file makes it easier for everyone.
Based on your topic label, this blog post gives a good description how to do a lookup across multiple sheets.

Br,
Anders

 
Posted : 20/11/2020 3:28 pm
Share: