Hi,
I'm sorry but this is no clearer. Your original mentioned only columns A, B & C. Now you've thrown in F Y & AA.
You need to clearly state which columns you want to compare, and then when a match is found between a value in a Sheet1 column and the same value in a Sheet2 column, which column from Sheet1 you want to pick up.
But importantly you need to manually add the results you expect to see and tell us which is the column containing the results.
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.
thanx newdoverman.
this is exactly what i want.
can you provide me the formula without clicking the cells or columns. eg. instead of showing table1ID, rather show like $A$2:$A$10.
you can provide me the formula for your own worksheet.
i tried it myself but its not working that way so thats y i ask.
one more thing if drag the last cell W10 further down will it automatically fill in the 4 digit codes (given that there is data entered in columns U and V beyond row10)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks