Find and match a text value for a corresponding number

**Neyme** · 04-07-2021, 01:55 PM

I would be really appreciative if the forum experts help me to come up with the formula to:

For each combination of SKU ID in column 'A' and Attribute# (columns 'D'-'J') on "Adobe TV Category on PLP" tab --> return a value from "value" column D for a given SKU ID and Attribute # from "Attributes_fillrate_processed" tab. For example, for SKU ID 5734900 and Attribute1='Screen size' on "Adobe TV Category on PLP" tab, the value listed on "Attributes_fillrate_processed" tab is 23.6 inches.

The sample file "TVs" is attached

Any help is so much appreciated!

**6StringJazzer** · 04-07-2021, 02:26 PM

This requires an array formula (or at least that's the solution I'm providing).

This formula can go in B4 then copy right and down:

Formula:

Please Login or Register  to view this content.

This is an array formula. After typing in the formula, do not hit ENTER--hit CTRL+SHIFT+ENTER. You have done it correctly if the formula in the formula box has {braces} around it. You cannot type in the braces; they are just an indicator that it is an array formula.

Note that some of your headings are not found in the data (High Dynamic Range Format, Smart Platform) and cause errors.

Updated file attached.

**Neyme** · 04-07-2021, 04:40 PM

Hi 6StringJazzer, your formula worked as a charm! Thank you so much!

**6StringJazzer** · 04-07-2021, 04:49 PM

Glad to help and thanks for the rep!

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

Find and match a text value for a corresponding number

LinkBack

Thread Tools

Rate This Thread

Display

Find and match a text value for a corresponding number

Re: Find and match a text value for a corresponding number

Re: Find and match a text value for a corresponding number

Re: Find and match a text value for a corresponding number

Thread Information

Users Browsing this Thread

Similar Threads

Google Sheets: Need to find the match number then enter the text

Google Sheets: Need to find the match number then enter the text

[SOLVED] Find and match cell text value on another sheet and paste row on correct row number

[SOLVED] Find the row number with a partial match to text in column A

Replace,Find/Search,Match to extract data from combination of text and number base on list

[SOLVED] Need help - Match number in column, find lowest number in that row, and return header name

[SOLVED] Find match, find related cell and return that number

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions