LinkBack URL
About LinkBacks
Hi,
I can see no matches between column B on CheckExpenseItems and column A on Accounts. However if there were this formula would return the column B of accounts
Formula:
=INDEX(Accounts!B:B,MATCH(B2,Accounts!A:A,FALSE),1)
Hi,
I can see no matches between column B on CheckExpenseItems and column A on Accounts. However if there were this formula would return the column B of accounts
Formula:=INDEX(Accounts!B:B,MATCH(B2,Accounts!A:A,FALSE),1)
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.
hi richard.
i tried the formula but it does not seem to work. can you have a look at the excel file uploaded above and kindly check why it is not working. i would be grateful my friend.
the file uploaded above contains many data than the one i showed above in the pics. my concern is the checks sheet. 2 columns of concern A and F in the accounts sheet.
Checks sheet column AA is the same as A above with values unevenly dispersed. Yes the are the same if you scroll down you may find very few data similar. actually i exported just 100 transactions to excel from quickbooks so i think thats y this issue.
anyhow i want to fill in column Y of Checks with values of column F of Accounts but with respect to column AA of Checks which will be matched (i think) to Column A of Accounts.
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.
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
Register To Reply
Bookmarks