Forum

Forums
Public Forums - For...
General Excel Quest...
Lookup data across ...
 
Notifications
Clear all

Lookup data across multiple sheets?

 
General Excel Questions & Answers
3 Posts
3 Users
0 Reactions
81 Views
RSS
 Anonymous
(@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
 Andrew Wilkie
(@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
 Anders Sehlstedt
(@sehlsan)
Posts: 974
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
Forum Jump:
  Previous Topic
Next Topic  
Share: