Nikki91775
Member
I am working on a price comparison sheet. I have my overall sheet of all items numbers with pricing. I have different worksheets set up for each competitor with their similar products and their pricing. In my worksheet all my vlooksups are working well except for one of the competitors tabs. I have even deleted it and recreated it, but the vlookup keeps coming back with a N/a.
My issue is when I go to the competitors sheet, the item number is there with a price. The item number is PX400/AA/TT/ZZ. I have even copied it from the competitors sheet and put it in my overall sheet thinking there was a character missing or something. Still is not working. If I change my last statement in the vlookup to "True" it adds all of the numbers together and give me an incorrect number.
I cannot figure out why it is not working. Any ideas?
My issue is when I go to the competitors sheet, the item number is there with a price. The item number is PX400/AA/TT/ZZ. I have even copied it from the competitors sheet and put it in my overall sheet thinking there was a character missing or something. Still is not working. If I change my last statement in the vlookup to "True" it adds all of the numbers together and give me an incorrect number.
I cannot figure out why it is not working. Any ideas?