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
The Price...
hi all
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>
<o:p></o:p>
Second => Once I have the row number I will then format the columns C:N...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.