Index function

[Guest]

I'm trying to match data from 1 spreadsheet to another using the index
function. I have tried formatting the data on each sheet to general, tried
the "Text to Columns" all to no avail.

When the results come back I get an #N/A.

VLOOKUP won't allow a false Range Lookup.

What can I do to make this work??

 

[bony_tony]

have you checked that the data you are getting an error message for has
an exact match on the other spreadsheet?

 

[Bob Phillips]

INDEX returns a value in an array, it doesn't do the matching. You need
MATCH or one of the lookup functions for that.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Bob Phillips]

Groping in the dark a bit here, but how about

=VLOOKUP('Sales by Club w-Demog'!$D5,'Spectra Data'!E9:AG3406,21,False)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)