Hi to all,
I have data in 2 sheets like this,
sheet1
SX1 SX2 SX3 SX4 SX5
AA ZZ AA GG -/-
in sheet2 i have data like this
SX1 SX2 SX3 SX4 SX5
AA AA AA GG TT
i am doing Hlookup to get value in only columns containing ZZ or -/- not in another columns, my aim is even if i drag my formula from 1st column to last column i should get lookup value only in these in the columns containing ZZ or -/-.
my expected results will be
sheet1
SX1 SX2 SX3 SX4 SX5
AA AA AA GG TT
How can i get this value as per my expectations is Hlookup and match function together will work?
i need help really to solve this problem because my data is so big and i can not do it manually searching for ZZ or -/-.
any help would be appreciated
Thanks in advance
Genetist
I have data in 2 sheets like this,
sheet1
SX1 SX2 SX3 SX4 SX5
AA ZZ AA GG -/-
in sheet2 i have data like this
SX1 SX2 SX3 SX4 SX5
AA AA AA GG TT
i am doing Hlookup to get value in only columns containing ZZ or -/- not in another columns, my aim is even if i drag my formula from 1st column to last column i should get lookup value only in these in the columns containing ZZ or -/-.
my expected results will be
sheet1
SX1 SX2 SX3 SX4 SX5
AA AA AA GG TT
How can i get this value as per my expectations is Hlookup and match function together will work?
i need help really to solve this problem because my data is so big and i can not do it manually searching for ZZ or -/-.
any help would be appreciated
Thanks in advance
Genetist