Hello, I have an excel file like below.
SV_plates Row Col IDs sample
SVI_01 A 1 1045 010-006P
SVI_01 B 1 1270 032-006
SVI_01 C 1 1274 034-014P
SVI_01 D 1 1276 035-016B
SVI_01 E 1 1277 038-022
SVI_01 F 1 1278 045-012
SVI_01 G 1 1282 047-011P
I want to add one column which is the value in the first column respectively. The condition is the cell value in 5th column matchs the value in the 4th column.
For example,
SVII_31 G 4 3291 1234
SVI_03 F 10 3965 3291 SVII_31
3291 matchs , then return "SVII_31" . In the above example, Cell E2 value is "3291", then we search D1:D65536, found D1="3291", then we add A1="SVII_31" to the new column. If not found, then noing added or add "NA" something.
Thanks for help.
Bookmarks