Link to home
Start Free TrialLog in
Avatar of Matt Pinkston
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.
Avatar of Matt Pinkston
Matt Pinkston

ASKER

and if there is no match the value should be 0
I tried this but think I have something wrong

=IFERROR(INDEX(recompete!H:H,MATCH($A3,recompete!$A:$A,0)),"")
ASKER CERTIFIED SOLUTION
Avatar of NBVC
NBVC
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial