Matt Pinkston
asked on
MSExcel Lookup Help
I have an excel spreadsheet with multiple tabs
I am working on a tab called summary
In all tabs there is one common column A which is the opportunity ID
What I am trying to do is create a lookup that will bring in the contents of column H from tab (recompete) when column A in summary equals column A in recompete.
I am working on a tab called summary
In all tabs there is one common column A which is the opportunity ID
What I am trying to do is create a lookup that will bring in the contents of column H from tab (recompete) when column A in summary equals column A in recompete.
ASKER
I tried this but think I have something wrong
=IFERROR(INDEX(recompete!H :H,MATCH($ A3,recompe te!$A:$A,0 )),"")
=IFERROR(INDEX(recompete!H
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER