Find a column by criteria and display in another worksheet

Closed
jesslm17 Posts 1 Registration date Thursday June 13, 2013 Status Member Last seen June 13, 2013 - Jun 13, 2013 at 06:13 PM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Jun 15, 2013 at 12:50 PM
Hello,

I have a worksheet with a several columns (example):

PP DR MM SS
5 3 2 7
4 9 2 1
2 9 4 4

I want to create a formula in another worksheet that finds and displays a column based on specific criteria.

Example- Find "PP" in range (a1:z1) and then display that specific column.

PLEASE HELP ME!!!!!!!

1 reply

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Jun 15, 2013 at 12:50 PM
jesslm17, Good morning.

I did an example for you.

https://www.sendspace.com/file/tnmu77

Take a look at it and tell me if it worked for you.


I hope it helps.

Best regards,
0