hi on google excel how would i got about it if i want to searh for a name in coloum A:A, once i find the name then search that row for a set bit of data in a cell, so i then want to find Hello, once its found the name and hello it then gives me the info in a set cell for the coloum it finds Hello on, does this make sense?
here is a example to hopefully help
https://docs.google.com/spreadsheets...it?usp=sharing
thanks
Hello do you need multiple results or just one??
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
it needs to find as many as is on the row then output them 1 at a time not all together
so for example based on sheet linked, search for cell A7, once found check cells b7:J7 any found with a input(cells D,E,F 7) put cells D1 into L7, D2 into M7 and D3 into N7, as all 3 of the cells had a value, does that make sense?
Last edited by Ditch1983; 03-07-2015 at 08:20 AM.
Use this in L2
=if($A2=$C$15,index($A$1:$K$1, ArrayFormula(IF($A2=$C$15,small(IF($B2:$K2=$D$15,COLUMN($B2:$K2),""),COLUMN(A$1)),""))),"")
and copy down and across...
hey thanks for that it works but i think i can do it a easier way, dont need to match to start with all i need to do is say search cells D1 to D50, in any cell the has "HI" i want it to find the value above "HI" in say cell A1 to A50 then out the info to cells E1 to E15 for example, but there will be multiple instances of "HI" in the rows in random places and for each one it outputs to another cell, does this make sense?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks