User Profile
davidclubb
Copper Contributor
Joined 12 months ago
User Widgets
Recent Discussions
Re: Using Countif to create a Lookup column
I am building an entire set of templates for our estimating program. Each summary page that I build will perform a vlookup using the results of the formula you have provided. In the industrial world 10" pipe are common, and so it is critical that a 10 is treated as such instead of a 1 every time.741Views0likes0CommentsRe: Using Countif to create a Lookup column
smylbugti222gmailcom=IF(D25=0,"",D25 & TEXT(COUNTIF('90 DEG NONREPAD NOZZLE WELDS'!$D$2:D25, LEFT(D25, LEN(D25)-1) & "*"), "0")) Copying the formula produced these results 1"1, 1"2, 10"1, 1"4. With this formula the number ten is being treated as a one. Do you have a solution for this?756Views0likes1CommentRe: Using Countif to create a Lookup column
smylbugti222gmailcomThe reason the first problem seemed to correct itself is because I used O instead of 0. I reverted back to using 0 and the first problem still persists. So, I used the formula provided, but nothing changed. Is there something I am missing?845Views0likes0CommentsRe: Using Countif to create a Lookup column
When I opened the file the problem fixed itself, because when I enter a "10" in the pipe size column the concatenation works. However, the problem moved to another column where vlookup is being used. Here's the formula: =IFERROR(VLOOKUP($D4,$AA$19:$AW$42,G4,FALSE),"") Any feedback on how to use the correction below is appreciated. Sincerely, David915Views0likes0Comments- 1KViews0likes0Comments
- 1KViews0likes0Comments
- 1.1KViews0likes5Comments
Groups
Recent Blog Articles
No content to show