how to search a reference in an array in openoffice calc?

Question

In a (large- like A1:ZZ200, unsorted) array I need to search the array & return the cell reference to the value being searched. Here's an example:
Find: ref. to 33
Array A1:C10:
57 63 21 82 95
27 69 05 11 33 37 28 53
02 09 68 29 91 83 92 71 61 63

(array starting at A1) correct result should be B5. What is/are the correct function(s) to complete this search?
thanks!

Answer 1

Perhaps I'm over simplifying your problem but unless you need to populate new cells the following will locate whatever cell reference for a value you are searching for in the array.



Select cell A1.

Click the "Edit" menu.

Click the "Find & Replace ..." sub-menu.

In the "Find & Replace" dialog box "Search for" section type in your value/text.

Click the "Find" or "Find All" button.



The cell address will display in the Name Box and the value in the value will appear in the Formula Bar.

Answer 2

It means hat the resutt of the formulation is merely too extensive for the cellular width. you are able to the two cut back the font length in that cellular, widen the column width or wrap the cellular content textile on your alignment settings. i take advantage of openoffice sxc information for many each and every thing I do. in case you want extra help, touch me which contain your question.

Answer 3

(if I remembers correctlys... ) this is one of those complex formulas inside a formula



if we put in A201

=MATCH( searchCriteria; LookUpArray; SortedUP[sortedDown] )

we CAN get a row number if the value we seek is there

then doing a MATCH( searchCriteria, A201:ZZZ201) would give us a range



VLookup won't work