Index function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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??
 
have you checked that the data you are getting an error message for has
an exact match on the other spreadsheet?
 
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)
 
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)
 
Back
Top