I have a SourceData that displays values as text and a subsequent table that pulls from it. How can I modify my Vlookup formula in Table1 so data is pulled as values and my Total row works correctly?
I have a SourceData that displays values as text and a subsequent table that pulls from it. How can I modify my Vlookup formula in Table1 so data is pulled as values and my Total row works correctly?
You can put a double-minus in front of your VLOOKUP function like this in C8:
=IFERROR(--VLOOKUP($B8,SourceData,2,FALSE),"")
then copy down. This will convert the text value to a numeric value. Do the same for D8.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks