use absolute reference isntead, change A1:D72 to $A$1:$D$72


"petes_girl via OfficeKB.com" wrote:

I could just behaving a very thick day but help would be very much
appreciated.

I have the following:

Sheet: PHSTB
Column A Column B Column C
1 J100 20 500
2 J100 30 100
3 J100 50 600
4 K200 20 700
5 K200 50 50

Sheet:YTD

Column A Column B Column C
1 J100 K100 K200

2 20
3 30
4 50

So I need the approiate data in the right cells on YTD and blanks where there
are no values or does not exsist. I have the following so far in cell A2:

=IF (VLOOKUP(A1,PHSTB!A1:D72,2,FALSE)="20",VLOOKUP(A2, PHSTB!A1:D72,3,FLASE),
"") this works nicely in A2 but when I drop it down to A3 and change it to
"30" of course it does not work as it only see the first line and gives a
result of "", how can I get this to read all the lines until it match's.

I hope this is clear.

Please let me know if you need any further info, and sorry if this has been
answered before but I couldn't track it down.

Thanks

Jane

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1