I am trying to find out how I can enter a number on a form and search a column "A1" for that number, if a match is found I would like to know the row number so I can pull data from that rown to form.
If the number is not found I would like to know it was not found.
This seems like it should...
I hope someone can help me. I have a construction estimate workbook that works as follows:
PO#, vendor#, Item#, Item Description, Price,
1500 7033 2345 2x4x12 3.54
1501 3454 2343 Termite Treat 100.00
i can't remember that formula where it looks for one word or phrase and then returns everything in the columns next to that.
in other words.
i have 5 colums with text and numbers in them in the last column stock movem,ent is indicated with either a z for dead or a range of other...
First => I'm trying to return the row number of the first instant of the word "Day 1" in a column, looking down the column.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
Second => Once I have the row number I will then format the columns C:N...