LinkBack URL
About LinkBacks
tgnomar 
Hi,
Post #4 doesn't alter what I said in #3.
Yes, uploading the file would assist.
Hi,
Post #4 doesn't alter what I said in #3.
Yes, uploading the file would assist.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Ok, I tried it but didn't work I will try it later at home and say something, thanks ¡¡
Last edited by tgnomar; 07-07-2014 at 07:09 AM.
ASK.xlsx
Hi is me again, I was trying with the function MATCH but I am not able to do it. The file has four columns with old and new histories and the units of both two. I need to look for the new in the old. If the new is not in the old it has to be, so the cell with the same unit and value "--.--" or just without value is the place where it has to be.
To sum up, at the end I will have only one list with old and news
Last edited by tgnomar; 07-07-2014 at 12:23 PM.
Hi
Formula:
=INDEX(B:B,MATCH(G2,A:A,FALSE),1)
will find the G value in A and return the value from B.
If that's not what you expect please add some manually calculated results.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks