[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

easy one: vlookup index match = nada

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... :'(
0
sullisnyc44
Asked:
sullisnyc44
1 Solution
 
barry houdiniCommented:
Is ProductsArray a single column (or row)?

barry
0
 
sullisnyc44Author Commented:
Ah. it is now. d'oh.

thank you.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now