Clever Geek Handbook

Compare two columns and the return value from the third column

Column 1

is my original data column, Column 2

and 3

is my link list. I want to index or match rules from Column 2 + Column 3

and compare to Column 1

and return the matched rule value to a result column within the same row.

enter image description here

Note that all values ​​are string (text) and unused numbers.

+3


source to share


2 answers


I may not understand your question, but according to what user1917229 suggested, you can just check if your original column is empty, and if not, return the first value in the first column and the value of column 3 in the second (per your update) ? For example, in a cell D2

(and is dragged and dropped):

=IF(A2="", "", A2)

And E2

:



=IF(A2="", "", VLOOKUP(A2,$B$2:$C$14,2,FALSE))

Note that I'm not sure what you wanted with +

, so this just literally returns it - if that's not what you want, hopefully the concept makes sense and can be adjusted.

enter image description here

+2


source


VLookUp might be what you want.



 =VLOOKUP(A3,$B$3:$C$12,2,TRUE)
0


source






More articles:


All Articles