Skip to main content
T
tcebulla1-Visitor
1-Visitor
August 3, 2015
Solved

VLOOKUP function - optional function

  • August 3, 2015
  • 1 reply
  • 2798 views

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...

Best answer by StuartBruff

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

Stuart

1 reply

S
StuartBruff23-Emerald V
23-Emerald V
August 3, 2015

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

Stuart

    T
    tcebulla1-VisitorAuthor
    1-Visitor
    August 3, 2015

    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

    S
    StuartBruff23-Emerald VAnswer
    23-Emerald V
    August 3, 2015

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

    Stuart

      Terms & ConditionsAccessibility statement