dismiss blanks in lookup
If your data is in A1:B100 and the value you want to lookup is in C1, try:
=INDEX(B1:B6,MATCH(1,(A1:A6=C1)*(B1:B6<""),0))
array entered with Cntrl+Shift+Enter (or you'll get an error).
"Manuel" wrote:
Hi, I have 3 columns
column A - 6 digit numbers that may repeat.(no blank cells)
column B - dates or blank (some blank cells)
column C - lookup formula
I want the cell in column C to look up a number in column A and return the
value in column B. If the cell in column B is empty, I want to find the next
match in column A and so on until it finds a date in Column B. Thank you in
advance.
--
Manuel
|