LinkBack URL
About LinkBacks
Formula:
Please Login or Register to view this content.
It looks up a number in a file and gives a value out of the column left of the number.
Anybody?
Formula:Please Login or Register to view this content.
It looks up a number in a file and gives a value out of the column left of the number.
Anybody?
What is that? I really have no idea what are you trying to do.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Is that what this formula does? Truly amazing!Originally Posted by Mverm0
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
This would be a simplified version of the same kind of formula.
Formula:Please Login or Register to view this content.
But in my example i have many more columns and rows in which i want to lookup a value and give the number in the column next to the value.
Let me state it this way, i would like use this formula:
=INDEX($C$3:$C$7 but also $E$3:$E$7 (not $D$3:$D$7), MATCH(A11,$B$3:$B$7 and $D$3:$D$7,0))
How would you write this down?
Yes really.Is that what this formula does? Truly amazing!
@Mverm0
Now you have correctly described the issue.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Is this a formula that you want on every row, or are you trying to find the Value A11 in any alternate column in any of the 65000 rows starting with column B and then return a value with the INDEX function which uses an offset from the row in which you find the value?
But as has been mentioned you really need to upload the workbook showing your original data and also the results you expect (manually created).
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi,
I have made an attachment.
You've a sheet with numbers and values.
In the sheet 'What', i've numbers which i would like to match.
And in the Sheet 'How it should be' it lists the 'Values' left of the numbers.
So how would this index/match function look like, remember the real data set is much larger.
Try this Array Formula to see if this is what you are trying to achieve.
Please Login or Register to view this content.
Thnx but,
But it gives an error: Typed formula contains a error. And it highlights the comma's.
After i had wrote ";" instead "," it gives "value!" and not the answer.
Last edited by a1b2c3d4e5f6g7; 06-22-2014 at 04:36 AM.
I made an attachment.
And split the number and values over the sheet. So now i want to find the number in the sheet 'numbers' in cell A1 and it should return the cell A1 from sheet 'values'.
Is this maybe a possibility?
This is an array formula which requires confirmation with Ctrl+Shift+Enter instead of just Enter. Did you confirm the formula with CSE? If not, select the cell which has formula in it, press F2 (function key), and hold down the Ctrl+Shift and then press Enter.
Thnx.
You are wright about the F2 function. But could you rewrite the formula with the same kind of document, but with more columns and rows? The rows end at 65001 and the columns at RJ. Is this possible and how would you rewrite this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks