Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup of identical values?
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 -- TobbeGardner ------------------------------------------------------------------------ TobbeGardner's Profile: http://www.excelforum.com/member.php...o&userid=35924 View this thread: http://www.excelforum.com/showthread...hreadid=557192 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup on 2 Values | Excel Worksheet Functions | |||
Summing lookup values | Excel Worksheet Functions | |||
How do I use vlookup with two lookup values? | Excel Worksheet Functions | |||
vlookup using two lookup values? | Excel Worksheet Functions | |||
Lookup values in one column to return another | Excel Worksheet Functions |