Hello:
Please refer to attached file.
I have data as shown in Sheet1.
I need to use some formula in Sheet2 to populate data for column A and Store in Row3
Let me know if you have any questions.
Thanks.
Riz
Hello:
Please refer to attached file.
I have data as shown in Sheet1.
I need to use some formula in Sheet2 to populate data for column A and Store in Row3
Let me know if you have any questions.
Thanks.
Riz
In D5 of Sheet 2 copied down:
=INDEX(Sheet1!$D$5:$H$21,MATCH(Sheet2!$A5,Sheet1!$A$5:$A$21,0),MATCH(Sheet1!D$4,Sheet2!$D$3:$P$3,0))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Shouldn't it be
=INDEX(Sheet1!$D$5:$H$21,MATCH(Sheet2!$A5,Sheet1!$A$5:$A$21,0),MATCH(Sheet2!D$3,Sheet1!$D$4:$H$4,0))
?
Enter in B5 and copy across to C5
Formula:Please Login or Register to view this content.
then enter in D5 and copy across and down
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hello AliGW:
Works for Column D in Sheet2, however copying the formula across does not work or i can manually change the formula for each column in sheet2.
I have over 40 columns in Sheet2 and same way will have data in Sheet1
Thanks
Riz
Hi Allkey:
Great, your solution works.
Thanks a lot
Riz
Thanks for the rep - glad to have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks