I have a pivot table problem, and it's hard to provide an example so I'll do my best to explain:
First formula in my main tab:
My first formula is working great. I am matching the value found in Column A8 of my main tab to a tab called 'Turntime' with this formula:
=IF(ISNA(VLOOKUP(A8,Turntime!A:B,2,0)),0,VLOOKUP(A8,Turntime!A:B,2,0))
This formula will include all possibilities (approximately 100) so that when each value matches, I will return the value found in Column C.
Second Formula:
I'm not getting my expected results with this formula:
I am attempting to match the names from my main tab (about 100 names in Column A) to my Turntime tab in Column E of about 50 names. What am I seeing is that when my main table doesn't match the value found in Turntime, I am not outputting the expected value.
Example:
Column A of main tab = CustomerA
Column E of Turntime Tab = CustomerA
Result of this match should return the value found in Column F, else a zero.
This is my current formula:
=IF(ISNA(VLOOKUP($A8,Turntime!A:F,6,0)),0,VLOOKUP($A8,Turntime!A:F,6,0))
Main Tab:
Column A:
CustomerA
CustomerB
....
Turntime Tab:
Column A: Column B: Column C: Column D: Column E: Column F: Column G:
CustomerA 13 78 CustomerA 10 0
Bookmarks