0

vlookup formula

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?

 

 

0 comments

Please sign in to leave a comment.