New to this forum but a pretty experienced excel user.
Does anyone know how to return which column (by number), that a given value on a specified array (row) exists in?
For example, if for the below string or row of numbers, is there a function that could tell me that "7" exists in column 4 of this array or row?
1 4 5 7 8 4 9
Ultimately trying to incorporate this with a VLOOKUP, but don't know how to indicate what column a given value may exist in?
Thank you for the help.
Hi and welcome to the board
You have posted in an Access forum. Is that what you need?
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
No....I thought I had posted in the excel function and database forum?Originally Posted by arthurbr
question closed, since re-posted in Excel Worksheet Functions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks