trying to use Vlookup function where table array and other table are subtotal tablels getting NA and Div#/0

Question

both of the tables are Part of a Subtotal Table(only want 2nd level of the subtotal table not entire table)I have a table that is the lookup table(table array) it has product ids that are #' s pull from Part of a text field - I copied and pasted as values using visible cells only - seems ok -Assume I have to do this - think since it is the common field(lookup value must Just be a value and not a calculation result???)

then go to the other table where i put the Vlookup function is - the common fields are the product ids - again they are numbers but made them text fields

also tried to make them both number fields but get same NA and Div#/0

 I have =Vlookup(g5,lookupnew,2,false)      lookupnew is the named range from the main subtotal table with only the 2nd level that I want showing???is this where the problem is???  g5 is where the common field is from the current table to compare to the lookupnew  named array.

I am trying to return the 2nd column of the tablearray and it is a %

so not sure if my problem is the subtotal table??? how can I just see the second level????

Having issure visible cells only and copy paste - when set to 2 level - subtotal first category messed up???

thanks,

bkel

Answer 1

HI,

There is no mistake I can spot in your formula.  What are the dimensions of lookupnew?  Ensure that G5 has the same spelling as the entries in the first column of your named range (there should be no extra spaces?)