Hello Everyone,
I have a table with values going down column A and across row 1. I would like to build a function that would look at the intersecting values and look them up in the seperate tab. If found, display the column header.
Here is a short example:
tables.jpg
I tried to upload the file but the site is not working properly for some reason. Not sure why becaus eI have done it in the past. I will try again later.
Thnak you for your assistance,
Stephen
Last edited by bigbavarian; 06-04-2013 at 09:44 AM.
As you have values in a row and a column and need to find intersecting values, you would use a combination of the INDEX and MATCH functions, however it is not very clear from your description what you are trying to achieve here?
Have a go at that upload again ;-)
I am having issues trying to upload. Is there a file size limitation? I went into manage attachments, am prompted to upload, select the file and it appears as if it will upload but never appearn in my list of files.
Here is the attachment. There was a file size limitation.
I've included one "Key" column in the lookup table. Have a look, let me know if it's not clear.
KR
That is awesome. I was thinking of trying the concat but could not get it to work right. Thank you for the assistance.
The code takes less than a minute as you have large data. The result is in lookout sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks