S
Sam_sebai
Is there a way that I can search for a string without using lookup, I don't
want t o sort any columns or rows.
This is what I would like to do:
Search for if (Sheet1!b2= a2) and (sheet1!c2=b2) then place the string from
Sheet1$c2 in the current cell
This will be copied down to 100 cells in the current sheet.
I tried sumproduct, but it didn't work.
Thank you in advance
want t o sort any columns or rows.
This is what I would like to do:
Search for if (Sheet1!b2= a2) and (sheet1!c2=b2) then place the string from
Sheet1$c2 in the current cell
This will be copied down to 100 cells in the current sheet.
I tried sumproduct, but it didn't work.
Thank you in advance