I have a lookup table sheet I work with with a table that uses two criteria to produce a result. My spreadsheet includes both of these keywords in columns far away from one another. What I want is to type my keyword into column A and the second keyword into column D and for the coordinating sentence from my lookup table sheet to appear in column H. It must go through the lookup table sheet. If clarification is needed please let me know and I'll try to explain the problem better. Thank you.
I do not understand what you want. You habve two tabs. I do not know which one is the lookup table sheet. You talk about columns A, D & H... but the entries in these columns do not seem to match the text. Please amend and upload a sheet where the text MATCHES the sheet... include a few expected answers as well, so we can see the logical pattern.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi Glen,
I have attached a more clear document. Currently, the formula I'm using =LOOKUP(2,1/(A3:A10=A12)/(B3:B10=B12),(C3:C11)) works on my lookup table sheet.
However, I don't think it's the right formula for me to use for this project. For my project, I must have a lookup table on a separate sheet from my results.
My 'Example Spreadsheet' sheet is very close to the one I'm using for my project. It has many columns for multiple product details. Each Woman's Sun Hat comes
with a description. The Men's Sun Hat comes with a different description. What I want is a formula to have in my 'Description' column that when it reads 'Sun Hat'
in column A, and 'Womens' in column D it goes to the lookup table and picks the coordinating description.
Let me know if I can clarify any other details. There are multiple moving parts to this.
Thank you
Change column D to Women and Men instead of Womens and Mens (the two sheets use different terms)
=INDEX('Lookup Table'!$C$3:$C$6,MATCH(1,('Lookup Table'!$A$3:$A$6=D2)*('Lookup Table'!$B$3:$B$6=A2),0))
Works perfectly. Thank you!
You're welcome.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks