Hi
Im Attaching a sheet where in "Master Ref" Sheet H Column, I need the reference to be taken as G2, and it has to look up in sheet "Check " , Match the same in Column A and return to the exact value as in B Column.
If anyone could help.
Tried Vlookup, but not happening
Faisal
We normally use index and match
Formula for H2
=INDEX(Check!B:B,MATCH(G2,Check!A:A,0),1)
Last edited by mehmetcik; 02-20-2019 at 02:52 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Put this on H2 and copied down as necessary:
=IFERROR(INDEX(Check!$B$5:$B$551,AGGREGATE(15,6,(ROW(Check!$B$5:$B$551)-ROW(Check!$B$5)+1)/ISNUMBER(SEARCH($G2,Check!$A$5:$A$551)),COUNTIF($G$2:G2,G2))),"")
You could use VLOOKUP but it will only return the first matching entry, as will a simple INDEX/MATCH.
Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks