Hi,
I have this sheet "Chart"where I have done a data validation in cells,B4 & D4.At the change of validation it pulls the data from Mastersheet,now the validation is only working for item "KOLKATA" in cell b4 but its not working for item "WB",for which its going to pull the data from columns F,G,H,I in master sheet.
Hello,
your formula
=IF(B4="KOLKATA",OFFSET(INDIRECT("MASTER!A"&MATCH($D$4,Master!$A:$A,0)),ROW()-6,COLUMN()-2),OFFSET(INDIRECT("MASTER!A"&MATCH($D$4,Master!$F:$F,0)),ROW()-6,COLUMN()-2))
has several problems. Starting in B8
B4="KOLKATA" should be $B$4="KOLKATA" so it stays the same when copied down and across.
The indirect reference in the FALSE part of the IF statement relates to column A, so you will not get values from column F. The correct statement should be in B8
=IF($B$4="KOLKATA",OFFSET(INDIRECT("MASTER!A"&MATCH($D$4,Master!$A:$A,0)),ROW()-6,COLUMN()-2),OFFSET(INDIRECT("MASTER!F"&MATCH($D$4,Master!$F:$F,0)),ROW()-6,COLUMN()-2))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks