Hi,
Do I have formula that will match the columns between sheet 1 and sheet 2 and get the corresponding value when it matches.
Sheet 1
RA45t.png
Below is Sheet 2
j5OEO.png
Example: Name Agentporta will be appended by random numbers at the start and end of the name like sec02552Agenportaportno I compare the two and if the name matches, I get the corresponding ticket no from Sheet 2 and paste it into Sheet 1.
I am trying to use INDEX & MATCH formula but getting confused.
- You post on wrong subforum, for formula based solution, you should post on http://www.excelforum.com/excel-formulas-and-functions/
- Formula on Sheet1!B2 :
Formula:
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Thank you
You are welcome, thanks for marking the thread as solved and for the rep. points.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks