We help IT Professionals succeed at work.

easy one: vlookup index match = nada

sullisnyc44
sullisnyc44 asked
on
if I match the contents of 2 cells on 2 separate sheets like this I get TRUE

=A2='Products'!a2

if I do a vlookup or index/match I get #n/a
=MATCH(A2,ProductsArray,0)

what's going on? I copied just the values to new sheets to avoid any potential formating issues

still the same... :'(
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2013
Commented:
Is ProductsArray a single column (or row)?

barry

Author

Commented:
Ah. it is now. d'oh.

thank you.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.