VLOOKUP or INDEX or whatever formula over 2 workbooks and multiple sheets with different ranges needed

casexcel

New Member
Joined
Nov 29, 2007
Messages
21
We are a large food service company for a university. Even though we're using Google Sheets for all of these, the formula will be the same.

We are currently using Google Sheets to create our recipes. We need to pull ingredients from multiple vendors in order to cost them out.

Costing Sheet:
1622651316539.png

Current formula in C14:
1622652572466.png


The formula works now because I only have 1 vendor and range. I tried adding another Importrange array formula but because they are different ranges and because vendors use the same item numbers, I cannot get it to work.

I need a formula in C14 that can look at the proper vendor tab based on what Vendor Code is entered.

Vendor Lists: Workbook name: Vendor order guides
Multiple Tabs:
1622651115775.png


Vendor 1 Tab (V1):
1622652810887.png


Vendor 2 Tab (V2):
1622652877868.png


Vendor 3 Tab (V3):
1622652983695.png
 

Attachments

  • 1622651039805.png
    1622651039805.png
    80.8 KB · Views: 12
  • 1622651382173.png
    1622651382173.png
    8.5 KB · Views: 12

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Correction in sentence:

I need a formula in C14 that can look at the proper vendor tab based on what Vendor Code is entered and pull the description based on the item number entered
 
Upvote 0

Forum statistics

Threads
1,223,405
Messages
6,171,925
Members
452,433
Latest member
Woodchuck76

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