Hi
I am looking for a way to find a value and return the value of the cell next to it and was wondering if any of you clever people can help?
Example
I have a table of data in A-G
In cell H I want to find the value of E4 in B:B and return the value of the cell to the right so in this case C4.
Is this possible?
Jess
Try:
Formula:
Please Login or Register to view this content.
It will be much more efficient if you use smaller ranges than entire columns, though - for example:
Formula:Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
THANK YOU SO MUCH!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks