Is there anyway to use VLOOK with index

[Closed]
Report
Posts
1
Registration date
Wednesday February 13, 2013
Status
Member
Last seen
February 13, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello, I have hard time to solve this: I have problem like this:

1st worksheet I have a table similar than this:
A B C D
1 DOG 1 WHITE
2 BROWN
2 CAT 1 SMALL
2 MEDIUM
3 BIG

2ND WORSHEET WANT SOMETHING LIKE THIS
animal type subdivision specific
(enter #) (Formula 1) (enter #) (Formula 2)

Example of what I want:
1 dog 2 brown

For the formula 1 I solve it with the VLOOK not problem my column Type(formula 1) return the type of animal.

But for the second formula I need to check both numbers that I enter on the 2nd worksheet (animal & subdivision) and match it in the 1st worksheet, in order to get the right specific.

I apreciate your help


Related:

2 replies

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
Hi jsrodriguez2001,

A little clarification is needed with respect to your example. Please upload a sample file to the following website:

https://authentification.site

Note: Before you upload any files please make sure there is no personal or confidential information contained in it.

Please do write back to us.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
most easy way would be use of custom formula

other option could be
instead of this
1 DOG 1 WHITE
      2 BROWN
2 CAT 1 SMALL
      2 MEDIUM
      3 BIG

have
1	DOG	1	WHITE
1	DOG	2	BROWN
2	CAT	1	SMALL
2	CAT	2	MEDIUM
2	CAT	3	BIG

then u can use https://www.mrexcel.com/board/threads/vlookup-with-multiple-columns-formula-needed.610062/