# INDEX, VLOOKUP, MATCH? two variables

#### jbrandau

##### New Member
I'm trying to lookup a value in a table based on two criteria:

If the account number matches and the item number matches, return the purchase price - I've been using the following formula, but it's returing values that don't match and I'm not sure why...

=INDEX(range in colum containing value from results table,MATCH(item number from table in another sheet,IF(range in column contating account number from results table=account number ,range of item numbers from column in results table)))

I've entered this formula using Ctrl+Shift+Enter

Any ideas why it isn't working?

Thanks!

### Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

#### pgc01

##### MrExcel MVP
Hi

You are not doing an exact Match().

Try the exact same thing but use Match() with 3 parameters instead of 2, and use 0 (zero) for the third parameter.

#### T. Valko

##### Well-known Member
I'm trying to lookup a value in a table based on two criteria:

If the account number matches and the item number matches, return the purchase price - I've been using the following formula, but it's returing values that don't match and I'm not sure why...

=INDEX(range in colum containing value from results table,MATCH(item number from table in another sheet,IF(range in column contating account number from results table=account number ,range of item numbers from column in results table)))

I've entered this formula using Ctrl+Shift+Enter

Any ideas why it isn't working?

Thanks!
What version of Excel are you using?

If the combination of account number + item number are unique then you can use a normally entered conditional sum formula.

Replies
3
Views
141
Replies
4
Views
78
Replies
1
Views
281
Replies
8
Views
69
Replies
12
Views
131

1,191,584
Messages
5,987,479
Members
440,097
Latest member
Wint

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back