Hi im currently trying to lookup the value in column G in the from and to columns (B4 and C4 down) and return the corresponding date from column D into cell H. Any help will be greatly appreciated. The dates are in order but the other values are not in any order.
Thanks
Hi and welcome to the board
First sort the From column Ascending then enterin H3 and pull down as needed=LOOKUP(G3,$B$4:$B$25,$D$4:$D$25)
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
Sort first column and:
=VLOOKUP(G3, $B$4:$D$25, 3, TRUE)
"Relax. What is mind? No matter. What is matter? Never mind!"
use
=INDEX($D$4:$D$25,MATCH(RIGHT(G3,5),INDEX(RIGHT($B$4:$B$25,5),0))) and copy down
see the attatch file
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Azam, what is the point using 3 functions when one will do?
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
it is my mistake
the function given by you is correct solution
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Can i sort the columns so they data in the From, To and Date all stay together. As in the dates correspond to that data range and i need it to sort together
Put mouse in B column
select all (Ctrl+A)
Sort (Right click -> Sort A->Z)
"Relax. What is mind? No matter. What is matter? Never mind!"
Doesnt that sort each individual column from a-z
Try and see..
That will sort B column but if you select all data it will keep values in the same rows.
If you take only B column it will sort only B without moving other data.
"Relax. What is mind? No matter. What is matter? Never mind!"
All sorted, thank you very much for the help all
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks