jwalkerack
Board Regular
- Joined
- Jun 19, 2013
- Messages
- 81
Hi there ,
i have a column of data which i am looking up in a table
The data has come from a few different sources. So i can not be 100 percent its not contained in the table , It might just under another name
What i would like to do , is do the first look up , if the value is not found and returns the next look up i would like the vlookup to search again
At the moment my code for the look up is Column 1 is the index column
=VLOOKUP(A2,Short_Names!$A$1:$C$573,1,FALSE)
i like to be able to make column b the index line
=VLOOKUP(A2,Short_Names!$B$1:$C$573,1,FALSE)
Is there a way i can combine an if statment or something so i would be able to check again if not found. Thanks a lot
=VLOOKUP(A2,Short_Names!$A$1:$A$573,1,FALSE), =VLOOKUP(A2,Short_Names!$B$1:$C$573,1,FALSE) , =VLOOKUP(A2,Short_Names!$C$1:$C$573,1,FALSE)
i have a column of data which i am looking up in a table
The data has come from a few different sources. So i can not be 100 percent its not contained in the table , It might just under another name
What i would like to do , is do the first look up , if the value is not found and returns the next look up i would like the vlookup to search again
At the moment my code for the look up is Column 1 is the index column
=VLOOKUP(A2,Short_Names!$A$1:$C$573,1,FALSE)
i like to be able to make column b the index line
=VLOOKUP(A2,Short_Names!$B$1:$C$573,1,FALSE)
Is there a way i can combine an if statment or something so i would be able to check again if not found. Thanks a lot
=VLOOKUP(A2,Short_Names!$A$1:$A$573,1,FALSE), =VLOOKUP(A2,Short_Names!$B$1:$C$573,1,FALSE) , =VLOOKUP(A2,Short_Names!$C$1:$C$573,1,FALSE)