Search results

"1" mean for example : sheet2!A2 (thats "10")i search in sheet1!A:A, and i get last result founded and i look at colomn B for what is there, if there is "yes" in sheet2!B2 i write "1", if there is "no" then there i write "3"...after all i found that last result after search is in sheet1!A3 and...

hmmm i simplified a little...... (there in my work file i dont have cases to not find a number from sheet2 in sheet1) from !sheet2 i need to select each cell from column A(extract data from one cell) and search in !sheet1 column A for extracted data and read next cell ready to last result of...

oops didnt thinked about that here is google docs link to example file, thanks https://docs.google.com/spreadsheet/ccc?key=0AjkXfW-WjJOqdElZQm44SXhwUkdZUlVvc0JydzBVZkE#gid=0

Hi SirJB7 im kunda noob at this part of excel, if someone can at least can give me some tips about what function to use and i will try to learn that function... https://www.youtube.com/watch?v=E0bQXtw44Kw - thats an example of excel that i work with

Hello there, i will be verry happy if someone could help me. At work i do every week a statistic in excel and i need to analise around 2000 number and i do that manualy, look at this video to understand the ideea and what i do : https://www.youtube.com/watch?v=E0bQXtw44Kw can i code all this...