Previous Topic Next Topic

Is there anyway to use VLOOK with index

Closed
jsrodriguez2001 Posts 1 Registration date Wednesday February 13, 2013 Status Member Last seen February 13, 2013 - Feb 13, 2013 at 03:58 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 13, 2013 at 07:15 AM
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


2 responses

Answer 1 / 2
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Feb 13, 2013 at 06:54 AM
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.
0
Answer 2 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 13, 2013 at 07:15 AM
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/
0