T
TobbeGardner
Hi,
I have an worksheet with data like:
123, 1
124, 1
124, 2
125, 1
125, 2
In another worksheet, the alarm codes above are translated:
123 = "Alarm text 1"
124 = "Alarm text 2"
125 = "Alarm text 3"
And in the third worksheet, the action is translated:
1 = raise
2 = cease
What I would like is the possiblity to convert the three worksheets
into:
Alarmtext, raise?, cease?
"Alarm text 1", yes, no
"Alarm text 2", yes, yes
"Alarm text 3", yes, yes
Using only vlookup, I only get the first value in the first table, i.e.
I need a way to find the second (or third) value in column two with the
same id as in column one.
Thanks in advance!
Regards,
Tobbe G
I have an worksheet with data like:
123, 1
124, 1
124, 2
125, 1
125, 2
In another worksheet, the alarm codes above are translated:
123 = "Alarm text 1"
124 = "Alarm text 2"
125 = "Alarm text 3"
And in the third worksheet, the action is translated:
1 = raise
2 = cease
What I would like is the possiblity to convert the three worksheets
into:
Alarmtext, raise?, cease?
"Alarm text 1", yes, no
"Alarm text 2", yes, yes
"Alarm text 3", yes, yes
Using only vlookup, I only get the first value in the first table, i.e.
I need a way to find the second (or third) value in column two with the
same id as in column one.
Thanks in advance!
Regards,
Tobbe G