Hi
I am trying to achieve the following without much success i have tried match,and,ifs, vlookup but i cannot tie it all together etc ! ahh
Basically i have two sheets and i want to compare between them and extract a number from next column.
Cell x = i want to lookup value on sheet2 d2 that matches value on sheet1 column e:e , if match found i need to check if sheet2 e2 matches number in next column on same row as found in lookup on sheet1, if same cell x = sheet1 column h on same row found using lookup?
Hope this makes sense
hope can help
I am trying to achieve the following without much success i have tried match,and,ifs, vlookup but i cannot tie it all together etc ! ahh
Basically i have two sheets and i want to compare between them and extract a number from next column.
Cell x = i want to lookup value on sheet2 d2 that matches value on sheet1 column e:e , if match found i need to check if sheet2 e2 matches number in next column on same row as found in lookup on sheet1, if same cell x = sheet1 column h on same row found using lookup?
Hope this makes sense
hope can help