Lookup data across multiple sheets?

General Excel Questions & Answers

Last Post by Anders Sehlstedt 4 years ago

3 Posts

3 Users

0 Reactions

8 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?

Posted : 20/11/2020 8:04 am

Anders Sehlstedt

(@sehlsan)

Posts: 957

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

26 Forums
7,172 Topics
31.5 K Posts
7 Online
34.8 K Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed