Vlook up with if statment

J

jonespandrew

New member
Joined
Jan 27, 2016
Messages
122
Reaction score
0
Points
0
Hi What I am trying to create is as follows

If z2=failed then look up the work order number from work order field

is this possible
 
Not sure where your fields are or where your results but would look something like this:
if(Z2="Failed",(VLOOKUP("Workorder", A2:B100, 2, FALSE),"")

 
Hi this is how is should look but keep gettin error message

=if(Z2="Failed",(VLOOKUP([Work Order Type], A:A, 1, ),"")
 
Where is Work Order Type coming from?
This is where the error is
 
Also, If you don't specify False your table needs to be sorted alphabetically (Annoying but true)
 
Its Working now but trying to do get value field to show text no number
 
What are you trying to achieve with =if(Z2="Failed",(VLOOKUP([Work Order Type], A:A, 1, ),"") ?

It looks up it's value in a one column range, thus returning the same value??? VLOOKUP needs at least two columns to work, one lookup column, the second where to look up.

Please post a sample sheet Thx
 
Hi I am have an iusse with this =IF("REACTIV_DATA!Z2="Failed",(VLOOKUP("[Work Order]",REACTIVE_DATA!1:1048576,False),""))

its same forumula as aboved but the forumula is on one sheet and data on the other and does not work

in english it reads

If Sheet2 z:z=Failed then vlookup work order number and display it
 
You must log in or register to reply here.
Back
Top