I am working with 2 large sheets of data in MS excel 07
In the attachment I've given what I have already. What I want to do is move the costs from sheet 1 to its corresponding product in sheet 2, such that in column 3 of sheet 2 has all the correct costs.
Something like;
=IF(B4="","",VLOOKUP(A4,'1'!A:B,2,0))
?
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
Please Login or Register to view this content.
1. If you use whole-column references (as per my example) the solution will be more future-proofIn C4
=VLOOKUP(A4,'1'!$A$2:$B$5,2,0)
2. If you use an if (as per my example) you won't get #n/a errors inbetween days
In every other way, the proposed solutions are identical.
thanks a lot. how do i give you good feedback or whateverOriginally Posted by Cheeky Charlie
That'll dothanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks