Thread: search across row for nearest value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default search across row for nearest value
Try in say, A2, array-entered*:
=INDEX(1:1,MATCH(TRUE,(1:1<""),0))
which returns the value from row1

*press CTRL+SHIFT+ENTER to confirm the formula
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Wolf Crick" wrote:
I am looking for a function that will search across a row of empty cells to
find the one cell that has a value; and then bring that value to the formula.

Additionally, I am looking for a function that will search across a row of
empty cells to find the nearest cell that has a value; and then return that
value.
Reply With QuoteReply With Quote