LinkBack URL
About LinkBacks
Hi, i have a large formula in column B looking up column H
Im looking to bring back data with an offset from column G into column A
I have put the examples highlighted in yellow.
Can this be done?
Hi, i have a large formula in column B looking up column H
Im looking to bring back data with an offset from column G into column A
I have put the examples highlighted in yellow.
Can this be done?
Hi,
maybe in a7 and below
Formula:
Please Login or Register to view this content.
Hope it helps
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
That works great but if the there is any of the same numbers it comes back with the same text.
Hi,
maybe array INDEX to be confirmed with control+shift+enter (very important)
Formula:Please Login or Register to view this content.
Please see the attached file
Hope it helps
its seems to work with the amount of data within the spread sheet, but when I add more it stops working.
I have dragged down the arrays but it still comes up with NA - the thing that seems to effect it is the row part of the formula.
Any advice?
Hi,
I'd need again a sample file. maybe you did not confirm correctly the formulas.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks