Here's the current formula for reference for column C:
=IF(B12="","",IF(OR(VLOOKUP(B12,M3:R67,6,0)="Profile",VLOOKUP(B12,M69:R302,3,0)="Metre"),"Length needed","-"))
Column A = Quantity
Column B = Product Code
Column C = Length
We have a number of products:
Some are classed as a "profile" (all of which are given a length)
Some are classed as an "accessory" (only a few of which requre a length)
- If 'A' is blank, 'B' and 'C' are blank
- If 'A' has a quantity, column 'B' shows "Ref Needed" text which you need to manually type in (it's just a prompt)
- Once you have specified the reference in column 'B', Cell 'C' (in the same row) references the tables above in the VLOOKUP (the first VLOOKUP is a table for the profiles, the second VLOOKUP is a table for the accessories)
I want Cell 'C' to recognise from the value in column 'B' if a length needs specifying or not. If yes, then show a prompt type of "Length needed", if it is not needed, fill the cell with '-'
As far as I can tell the equation above should work, but I'm getting an #N/A error, any ideas?
Edit: Profile shows incorrectly in the equation above (space in the middle of the word), but it's a forum thing, not in my excel formula
Bookmarks