I don't think I understand what your looking for. Is each row a unique record?



Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


" wrote:

Hanr3....

I am not sure this will work....tried, but my experience with vlookup
IS limited!
the store # can and is repeated several times on the s1.htm sheet. So,
how would I go about doing it with this variable in the mix?

This is what I have
VLOOKUP(C81,s1.htm!$A:$F,5,FALSE)*VLOOKUP(E2,s1.ht m!$A:$F,5,FALSE)
C81(where the store is),lookup array,the answer what I am trying to
retrieve,False
E2(where the question is), lookup array, the answer I am trying to
retreive(this is the same answer as above), False

I must be missing something here 'cause what I get back is #Value


Thanks for the help

Hans