Skip to main content
tcebulla1-Visitor
1-Visitor
Aug 3, 2015 1:34 PM UTC
Solved

VLOOKUP function - optional function

Hey I am trying to use VLOOKUP function to search a value....

and I want the answer to be "0"... when an exact match is not found... suggest..how can we do it...

StuartBruffAnswer
23-Emerald V
Aug 3, 2015 2:39 PM UTC

vlookup returns a vector, so use indexing to get at the value and then assign that to S as required.

Stuart

View in thread

6 replies

StuartBruff23-Emerald V
23-Emerald V
Aug 3, 2015 1:42 PM UTC

Replace NaN with 0 in the above example; uses the programming construct "on error" to trap the vlookup no-match error.

Stuart

Translate
    tcebulla1-VisitorAuthor
    1-Visitor
    Aug 3, 2015 2:26 PM UTC

    Perhaps my problem is still there.... As I am trying to use VLOOKUP for not a single variable but for a range of variables..

    Can you suggest how can I solve the following problem.... I have reaction matrix...at the restraint nodes..in order to calculate shear force and generalire the calculation for shear force.. I need a matrix S..which gives a value of zero at the unrestrained nodes....

    try.PNG

    Translate
    StuartBruff23-Emerald VAnswer
    23-Emerald V
    Aug 3, 2015 2:39 PM UTC

    vlookup returns a vector, so use indexing to get at the value and then assign that to S as required.

    Stuart

    Translate
      Terms & ConditionsAccessibility statement