Hi,
I have back data that will renew every month with different accounts and zones. They will have a 'result' every month. I want to match the zone and account for the relevant month and populate the result in a matrix - see attached sheet named front. It needs to pull this from the back data sheet.
I tried using index and match but couldn't figure it out, any suggestions?
Last edited by nickymac; 09-08-2011 at 07:07 AM.
Try:
=LOOKUP(2,1/(('Back Data'!$A$2:$A$16=D$1)*('Back Data'!$B$2:$B$16=$A2)),'Back Data'!$E$2:$E$16)
In D2 copied across and down.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Brillian, thanks for the quick response!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks