Search Target <= in Col. "B" to return Date in Col. "A"

U

u473

1. An inputbox for a Target amount (Integer)
2. Search that Target in Col. "B" for <= amount, same worksheet.
3. Return a Date in Col. "A" same row.
..
I cannot use VLookup because I understand the searched value has to be
in the leftmost column. What solutions do I have ?
Help appreciated,
J.P.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Column number of last column that returns value ignore formulas 8
Loop thru xx No. of sheets until the four strValue combo's are found 6
Find a date in list less or equal than target date 4
Index and Match - Errors 6
Transpose & reorg data from 2 WS to new WB 2
Resize a row but copy but skip columns I don't want to copy 6
Compare data set 1 with data set 2. Add to data set 2 if not found 0

Top