Easier way to write down this formula

**sktneer** · 06-21-2014, 12:23 PM

What is that? I really have no idea what are you trying to do.

**a1b2c3d4e5f6g7** · 06-21-2014, 12:37 PM

This would be a simplified version of the same kind of formula.

Formula:

=INDEX($C$3:$C$7, MATCH(A11,$B$3:$B$7,0))

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?

**Richard Buttrey** · 06-21-2014, 02:35 PM

Originally Posted by Mverm0

This would be a simplified version of the same kind of formula.

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).

**a1b2c3d4e5f6g7** · 06-21-2014, 05:54 PM

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.