Cross-posted at https://www.mrexcel.com/board/thread...olumn.1252835/
image001.png
I am attempting to return the value of other columns much like a VLOOKUP would; however, I need to find the applicable row/column to ensure a match and then if true return data from another column on that row and if there is no match I need to indicate as such. Attached is an example of what I have losing sleep over.
Last edited by 6StringJazzer; 01-29-2024 at 03:05 PM. Reason: added xpost link
CSV
Lookup Reference,WHAT ROW IS LOOKUP IN,WHAT COLUMN,INDEX/MATCH RESULT,"VALUE OF DATA IN ""DATA I NEED"" WHERE A# MATCHES F2:H6",COL1,COL2,COL3,DATA I NEED
pear,,,,,random,random,apples,myvalue1
apples,,,,,random,oranges,random,myvalue2
oranges,,,,,strawberries,random,random,myvalue3
strawberries,,,,,random,random,banana,myvalue4
banana,,,,,random,no-match,random,
,,,,,,,,
,,,,,,,,
A picture is not much use to us, especially one which can't be read very easily. It would be better if you attached a sample Excel workbook, by following the guidelines given in the yellow banner at the top of the screen.
Hope this helps.
Pete
The attached might possibly do the trick- there are probably better approaches out there, however.
Excel 365 user. To unblock a downloaded macro-enabled workbook, go to your "Downloads" folder > right click on the workbook name > click 'Properties' > check the 'Unblock' checkbox. You can now open the workbook.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/
I have added the link for you in post #1 because it's your first post.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks