Find a column by criteria and display in another worksheet

Closed
Posts
1
Registration date
Thursday June 13, 2013
Status
Member
Last seen
June 13, 2013
-
Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
-
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

Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
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,