Find and return corresponding first matching value found + transpose data

**mgcarino14** · 02-13-2017, 09:48 AM

Hi Experts!
I need help with writing a VBA code that will transpose data from Sheet A (UniqueItem), and finds the matching first level reaction from Sheet B (Cards) for each card, and return output on another sheet (Output).
There are 3 level reactions allowed for each item, but only the first matching reaction found in the card needs to be returned.
See attached excel file for data and expected output.

**jindon** · 02-13-2017, 10:47 AM

You have wrong results due to the strange transposed data from UniqueItem

Please Login or Register  to view this content.

.

**mgcarino14** · 02-13-2017, 11:05 AM

@jindon - thank you so much! Code works great!

**jindon** · 02-13-2017, 11:15 AM

You are welcome and thanks for the rep.

Find and return corresponding first matching value found + transpose data

LinkBack

Thread Tools

Rate This Thread

Display

Find and return corresponding first matching value found + transpose data

Re: Find and return corresponding first matching value found + transpose data

Re: Find and return corresponding first matching value found + transpose data

Re: Find and return corresponding first matching value found + transpose data

Thread Information

Users Browsing this Thread

Similar Threads

Find matching value, return value N rows down in same column where that value is found.

[SOLVED] Macro to find every employee id found in column B and paste on matching row

Find matching text from sheet2 in sheet 1, if found copy contents of matching value row

Check for a number of matching characters return value (if match is found) and location

Search to find matching cells and copy/transpose adjacent data to original sheet?

find matching value and return data from previous column

find name; search column; if date found-return 3 data pts; move to next row

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions