Formula to look up data from another tab based on multiple items

**kcstier** · 12-06-2019, 04:39 PM

I need help getting the data from master tab to display on Kevs tab. The formula should look up the data from the master sheet and display it on kevs sheet, matching the site from column A and category fields from row 1. Column A data and Row 1 data will be the exact same on each sheet.

Thanks for the help.

I included a test file where you could try this out to help me out. I can't seem to get it to work.

**MarvinP** · 12-06-2019, 04:49 PM

Hi kcstier,

Put this formula in B2 on Kevs sheet and pull it across and down.

Formula:

Please Login or Register  to view this content.

Vlookup with Match for Column.xlsx

**kcstier** · 12-06-2019, 04:56 PM

WOO WHOOOO, think you solved my problem. Going to implement into my larger test and see if it works. =) Thank you.

Formula to look up data from another tab based on multiple items

LinkBack

Thread Tools

Rate This Thread

Display

Formula to look up data from another tab based on multiple items

Re: Help - Need help with formula that looks up data from another tab based on multiple it

Re: Help - Need help with formula that looks up data from another tab based on multiple it

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Filter Data Based on Unique Column Items and Save the Workbook with Filtered Items

[SOLVED] Need to add items based on multiple matches.

Need to add items based on multiple matches.

Sum items based off multiple variables

Data Validation - Selecting multiple items with ability to deselect items

Formula to Count unique items based on multiple criteria including time period

[SOLVED] Need to count items in column that match multiple data items

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions