Using a formula to look up multipul values based on one other value.

[Browneh89]

Hey,

I hope I can explain this correctly. I'm trying to write a formula which looks at a value and uses it to pull up 2 different lines of criteria..

So in the first table it would look at the number in the area box and compare it to the second table.

it would then pull the code for requirement 1 and 2 in the lower rows in the second table.

I can't use XL2BB to better explain because I am at work!

Thank you for any help in advance!

 

[Browneh89]

If the formula is in G26, C8 has the route & you want the store number for anything that needs Wrap, then that formula looks fine.
In what way is it not working?

Yup they are in those locations. I'm not really sure why it won't work but it just pulls nothing so i'm assuming it's an error.

Is this the only method you can use for this?

 

[Fluff]

If you remove the Iferror portion, what do you get?

 

[Browneh89]

If you remove the Iferror portion, what do you get?

 

[Fluff]

In that case it can't find anything that matches, check that the value in C8 is exactly the same as the routes in col E.
Make sure no leading/trailing spaces & that they are all numbers.

 

[Browneh89]

In that case it can't find anything that matches, check that the value in C8 is exactly the same as the routes in col E.
Make sure no leading/trailing spaces & that they are all numbers.

Yup I checked everything and no luck. the formula is written in a merged cell if that is an issue although that typically plays up more with VBA macros then formulas.

the routes in Col E are actually pulled via a match index however I have a few I'm using as a test which are written manually and stiff no luck :/

 

[Fluff]

What happens if you get rid of the merged cells?
Merged cells are an abomination & should be avoided like the plague.

 

[Browneh89]

What happens if you get rid of the merged cells?
Merged cells are an abomination & should be avoided like the plague.

Nothing differently unfortunately it was one of the first things I attempted!

 

[Fluff]

In that case would you be able to share your workbook?
If so you will need to upload it to a share site like OneDrive or GoogleDrive, mark for sharing & then post the link you get to the thread.

 

[Browneh89]

In that case would you be able to share your workbook?
If so you will need to upload it to a share site like OneDrive or GoogleDrive, mark for sharing & then post the link you get to the thread.

TEST.xlsm

drive.google.com

 

[Fluff]

That's asking me to sign in, you need to mark the file for sharing & then post the link that you get.