Trying to write a vlookup within table builder but it isn't working??
The lookup value is in the Table builder I am creating but the table array is on another worksheet. (called List)
=np("eval","=vlookup([@[Item No.]],list!$b$3:$k$681,1,0)")
Anyone help please?