View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to locate the value?

Does anyone have any suggestions on how to locate the value?

There is a table as shown below starting from cell A1

A 4 B 2 C 9 [CELL F1]
V 8 K 0 S 3
J 99 O 8 W 7 [CELL F3]

The given value is S in cell K1
I would like to locate the value on the left hand side of S, which is 3, and
return in cell K2.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric