Matt Pinkston
asked on
Excel lookup
I have a workbook with two tables (Q2 & BPS)
Q2 is the main and receiving sheet column A (ID) and column B (BPS Status "empty")
BPS is where I want to pull data from column A (ID) and column B (BPS Status)
I need a lookup that will put the contents of column BPS-B into Q2-B when Q2-A = BPS-A
Q2 is the main and receiving sheet column A (ID) and column B (BPS Status "empty")
BPS is where I want to pull data from column A (ID) and column B (BPS Status)
I need a lookup that will put the contents of column BPS-B into Q2-B when Q2-A = BPS-A
I think I understand but I'm not positive. Would you be able to post the workbook itself?
ASKER
When I try that code it appears to partially work. Many of the values come up #N/A
They came like #N/A when it doesn't find a match, right?
ASKER
and some = 0
ASKER
yes on the #N/A
Can you post a sample file, where you're testing the formula?
ASKER
So it appears that if there is a match but the value is blank in BPS then it puts in a 0 and if there is now match you get #NA
is there a way around that?
is there a way around that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or if you are using Excel 2007/2010:
=IFERROR(VLOOKUP(...),"val ue if error")
=IFERROR(VLOOKUP(...),"val