I am doing a material takeoff from mechanical drawings (70 in total) and need to count the number of time a product code appears in a column. Then x it by the number of units needed in column next to the code. This will then give me the total number of products needed for the whole job. I was looking at VLOKUP and COUNTIF but kept getting errors. Any suggestions.
It sounds like your data being compared is inconsistent,
ie you could be trying to match text numbers with real numbers or vice versa
Try these variations:
=vlookup(A2&"", ... )
A2&"" will make the numeric product code into text nums, w/o impacting on its intrinsic value
This presumes your reference lookup data (ie the 1st col in the range) are text numbers
=vlookup(A2+0, ... )
A2+0 will make the text number product code into real nums, w/o impacting on its intrinsic value
This presumes your reference lookup data (ie the 1st col in the range) are real numbers
-------
Success? Celebrate it, hit the little star at the bottom left of my response
Last edited by Max, Singapore; 09-17-2012 at 04:59 AM.
Hi Max - Thanks for looking at this, I will try it out and let you know how it goes. There are a few other comments too so I'll give them atry and should come up with a workable solution
Kiwiscotsman
Last edited by Cutter; 09-18-2012 at 04:22 PM. Reason: Removed whole post quote
VLOOKUP will only return the first entry for a code.
It sounds as though you need to use SUMIF or SUMIFS to get the total number required.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi TMS - Never thought of SUMIF worth a try.
Kiwiscotsman
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks