LinkBack URL
About LinkBacks
I am looking for a formula that will look up in a given text in a specific column on a different tab and return the corresponding answer from different column. All answer that appliy.
I am looking for a formula that will look up in a given text in a specific column on a different tab and return the corresponding answer from different column. All answer that appliy.
Last edited by NBVC; 09-28-2010 at 12:28 PM. Reason: OP couldn't edit title
You can probably make use of VLOOKUP
Regards
I tried that one but no luck.
To pick up on Alan's point, a sample workbook with typical data would be helpful with a succinct definition of your requirements.
It may be that, if you are looking up something in column C but want data returned from column A or B, you could use INDEX/MATCH.
At the moment it's difficult to guess at your exact needs and why VLOOKUP isn't appropriate.
Regards
e.g.
=Vlookup(A1,'Sheet2'!A:B,2,false)
looks up value in A1 of active sheet, finds it in column A of Sheet2, and returns value from 2nd column in range A:B, ie. from Column B
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
From sheet 2, I want to find all entries in column A of sheet 1 with "excess" in it and retreive the data in column E that correspondes with data in column Aand return it to sheet 2 with all of the data.
Try this:
In G1 of Sheet1 enter:
=COUNTIF($A$1:A1,"Excess")
and copy down
in H1 enter:
=MAX(G:G)
Then in Sheet2, A2 enter:
=IF(ROWS($A$1:$A1)>Sheet1!$H$1,"",INDEX(Sheet1!E:E,MATCH(ROWS($A$1:$A1),Sheet1!$G:$G)))
copied down as far as you want.
Sorry, no luck with this one.
NBVC forgot a 0
=IF(ROWS($A$1:$A1)>Sheet1!$H$1,"",INDEX(Sheet1!E:E,MATCH(ROWS($A$1:$A1),Sheet1!$G:$G,0)))
See attached.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks Chemist.. you are correct... should've double checked the results.... :oops:
David, you might be able to get more assistance if you were more specific about your issue. You have provided only general issues so you have recieved only general responses. The more details you provide, the more specific the solutions. Want to try this again?
Alan
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks