Hello,
I have attached a file here. I have 2 lookup requested fields in H1 and G2 on Lookups Request tab. The lookuped fields are in CofAMapping tab. I had attempted to use Index and Match to lookup these 2 values but it doesn't work. Any help will be greatly appreciated.
Thanks,
Jackson
Last edited by jackson_hollon; 03-18-2019 at 12:15 AM.
You are getting errors, because you only have 4 matches in the entire range...
rows 33, 171, 220 and 868
and for all of those, your formula works fine
Here is another version of your formula...
=INDEX(CofAMapping!AG:AG,MATCH(G2&H$1,INDEX(CofAMapping!$AE$2:$AE$9238&CofAMapping!$AF$2:$AF$9238,0),0))
it may be a bit quicker
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
FDibbins,
Great. It works. Thanks.
Jackson
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks