How to find a number from a given data range?

R

Roshan

Dear Friends

I need to search the prize list of a scheme for those numbers which I have
with me. I tried the Excel Formulas like "IF", "MATCH", "LOOKUP", "ISNA",
"INDEX", used separately and in different combinations but failed. The above
formulas are only helpful if you search through a single coulmn but for a
range of column data they dont work and always gives error. Please help me.
Thanks.
 
J

Jacob Skaria

You can do it with formulas; Before that just few queries

--Since you have posted in Excel Programming group confirm whether you are
looking for a VBA solution or formulas

--Also suggest you to post some examples of your data and let us know what
you expect if a search string is found and what if not found.
 

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

Access Command button to look up and copy data from a query to a table 0
importing data from closed Excel workbook 2
how to use VBA code to create 'Select Data Range' userform. 4
How do I do "Range(A1).text" in a XL forumla? 3
Macro to insert value from range on different sheet and copy sheet 1
Simple code to find the empty cells in a range and cells with number 2
Range to increase/decrease with data 7
How to use a subset of a range? 1

Top