VLOOKUP Issue.... Help!!!

[Bennets04]

Hi people,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Need some help with making my life easier….<o></o>
<o> </o>
Ok I hope this makes sense and I have explained this enough<o></o>
<o> </o>
The document is made up of store names down the left then along the top the following headings “Visit 1” “Visit 2” “Visit 3” and “26 Week Visit”<o></o>
<o> </o>
On sheet 1 I have a list function so I can select a store (Qwerty) form a preset list of 100 stores, I enter a score for just visit 1. I then go back and enter the same store again and set visit 2’s score, then visit 3 and 26 week visit (It looks like the following….)<o></o>
<o> </o>
Qwerty 10 0 0 0<o></o>
Qwerty 0 12 0 0<o></o>
Qwerty 0 0 10 0<o></o>
Qwerty 0 0 0 20<o></o>
<o> </o> <o></o>
Then on sheet 2 I have the list of the 100 stores and the visits 1, 2, 3 and 26 in separate columns along the top<o></o>
<o></o>
The issue I am finding is VLOOKUP will only scan down and find the first entry “Qwerty” and input the 1 column reference given instead of continuing and plotting each of the separate scores onto the 1 line<o></o>
<o></o>
Help?!?!?! <o></o>

 

[T. Valko]

Hi people,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Need some help with making my life easier….<o></o>
<o></o>
Ok I hope this makes sense and I have explained this enough<o></o>
<o></o>
The document is made up of store names down the left then along the top the following headings “Visit 1” “Visit 2” “Visit 3” and “26 Week Visit”<o></o>
<o></o>
On sheet 1 I have a list function so I can select a store (Qwerty) form a preset list of 100 stores, I enter a score for just visit 1. I then go back and enter the same store again and set visit 2’s score, then visit 3 and 26 week visit (It looks like the following….)<o></o>
<o></o>
Qwerty 10 0 0 0<o></o>
Qwerty 0 12 0 0<o></o>
Qwerty 0 0 10 0<o></o>
Qwerty 0 0 0 20<o></o>
<o></o><o></o>
Then on sheet 2 I have the list of the 100 stores and the visits 1, 2, 3 and 26 in separate columns along the top<o></o>
<o></o>
The issue I am finding is VLOOKUP will only scan down and find the first entry “Qwerty” and input the 1 column reference given instead of continuing and plotting each of the separate scores onto the 1 line<o></o>
<o></o>
Help?!?!?! <o></o>

Maybe this...

Your data area:

Book1
	A	B	C	D	E
1	_	Visit 1	Visit 2	Visit 3	26 Week
2	Qwerty	10	0	0	0
3	Qwerty	0	12	0	0
4	Qwerty	0	0	10	0
5	Qwerty	0	0	0	20
Sheet1

Your summary area:

Book1
	A	B	C	D	E
10	_	Visit 1	Visit 2	Visit 3	26 Week
11	Qwerty	10	12	10	20
Sheet1

This formula entered in B11 and copied across:

=SUMIF($A$2:$A$5,$A11,B$2:B$5)

 

[ZacCerrato]

You'll have to respond more about how you have your two sheets set up. I don't think I understand what you are trying to do.

It sounds like you are trying to create the same information on Sheet 2 that you already have on Sheet 1?:

Sheet 1:

(Col. A) (Col. B) (Col. C) (Col. D) (Col. E)
(Row 1) STORES WEEK 1 WEEK 2 WEEK 3 26 WEEK
(Row 2) Store A 1 0 3 2
(Row 3) Store B 0 3 2 3
(Row 4) Store C 4 2 1 2

on Sheet 2 you would need a =Vlookup in every single cell for which you wanted to pull information from another specific cell.on a different sheet. E.g.

(Col. A) (Col. B) (Col. C) (Col. D) (Col. E)
(Row 1) STORES WEEK 1 WEEK 2 WEEK 3 26 WEEK
(Row 2) Store A =Vlookup() =Vlookup() =Vlookup() =Vlookup()
(Row 3) Store B =Vlookup() =Vlookup() =Vlookup() =Vlookup()
(Row 4) Store C =Vlookup() =Vlookup() =Vlookup() =Vlookup()

I'm sure this isn't your question though...

 

[Bennets04]

@T. Valko

Worked a treat!! many thanks

@ZacCerrato,

Again thank you for the reply

 

[T. Valko]

@T. Valko

Worked a treat!! many thanks

You're welcome. Thanks for the feedback!