If I didn't make a mistake in translating the formula, this should be the equivalent using normal cell references:
Formula:
=IFERROR(INDEX(Accounts!$C$2:$C$10,MATCH(Checks!$V2,Accounts!$A$2:$A$10,0)),"")
When in a table, don't drag the formulae down, go to the last cell in the table (lower right) and hit the TAB key. This will insert a new row into the table and bring with it the formulae from the row above it. That is the advantage of tables over ranges.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
thanx for the formula newdoberman.
i myself first translated to this same formula but it is not working for me. dont know where i am going wrong.
i have attached the excel sheet of mine.
kindly let me know where i am going wrong. the formula is pasted there so everything is ready for you this time.
qwqwqw.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks