I hope this makes sense. Ill pay fg to someone that helps me figure this out. I'm stumped, and this is the last part of my project

instructions not clear dick got stuck in excel spreadsheet

This post was edited by BruceLiChong on Feb 23 2019 10:53pm

Sorry, i've had a bit to drink so may be way off here, but is the question that J1, K1 and L1 are input from the other sheet, and we are trying to find the row where A = J1, F = K1 and G = L1? Can we just create a new concatenated column and then use a simple index(match) or vlookup formula to pull in D,E, and H that matched the concatonated cells?

So like create a new cell that is J1&K1&L1, and then match it with a newly created column that is A&F&G?

Edit: To explain further, assuming I understood the question correctly, I would make cell M1 =J1&K1&L1.
Then in column N I would make it =A&F&G and drag that all the way down to the bottom.

Then to pull in the value in column D it would be =Index(A1:I26000,Match(M1,N1:N26000,0),4)
E would be =Index(A1:I26000,Match(M1,N1:N26000,0),5)
H would be =Index(A1:I26000,Match(M1,N1:N26000,0),8)

Edit2: You can combine the concatenation steps with the lookup steps also to make it more clean.

This post was edited by Huggy8o4 on Feb 23 2019 11:09pm

Instructions not clear, Can't help if we don't know what you looking for

What should the answer of D E H be for your J1 K1 L1 ?

pretty sure more information is needed to solve.


can you just not sort & filter by?

ive got a guy pming me that totally understands it. We will see if we can get it

lol now moving on to trying this. ill let you know how it goes

This is where you use SQL and not excel commands. It's a join on the two data sources on the corresponding matching column values.

This worked. Delivered as promised 2/24/2019, 11:17:46 AM Sent -500.00 (3,616.00 -> 3,116.00) to Huggy8o4 (186.26 -> 686.26) excel help

I'm back to this project.

Is it possible to auto filter based on the value of another cell? H4 and J4 are selected via another sheet. I would like to be able to filter the data based on these selections.






What I would like to do now is, if H4 and J4 are filtered, I would like to be able to display the top 10 possibilities of Column B, based on the highest value of Column D

This post was edited by Orv on Mar 3 2019 05:06pm