Hi im trying to get a time from a row with two lookup criteria the issue im having is i cant bring the data back because of the gap between the names in column A please see attached.
example
Luke Andrews Phone would be 02:03:04
If you can help, THANKS!!
With the macro below to fill the gaps.
After that with an pivot table.
See the attached file.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi thank you for your reply, I cant fill in the gaps it needs to be the same layout without macros also
And why is that?
I dump that data and on a daily basis, I was just looking for a formula
Then it is a small job to run to macro to fill the gaps.
It will make it much easier to find a formula that fits your needs.
try this.. hope this works..
or you can do it like this.. i changed you table..
=OFFSET(A3,MATCH(E4,$A$4:$A$20,0)+LOOKUP(F4,{"chat","email","phone","Text"},{0,1,2,3}),2,1) should do it
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you all, MarinDWilson that worked perfectly! Thank you all!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks