Vlookup nesting

[love2myfriends]

I'm having trouble trying to use multiple vlookups together, which I don't even know is possible or not. Basically, I have a table that is exported from an application, so it's always the same, and copy/pasted into excel sheet over the previous day's table. The table has many locations and multiples of some of those. One of the columns is a sequence number so it'll show 1-10 if there were multiples of one location. On another summary page, I am using vlookup to search for a certain location in the table and kick out a number from another column in the table.

My problem is that if there are multiples for a location, the vlookup will only kick back the first number for the first value find in the table and not search the rest of the table. Is there a way to add vlookups together to have it search for the location first and then search by the sequence number before it kicks out a value? Or any other mix of functions to get this done like match or index?

 

[asad]

Hello and welcome to the board.

It will be easier for us to help you if you post a sample of your data.

 

[gurtej176]

I'm having trouble trying to use multiple vlookups together, which I don't even know is possible or not. Basically, I have a table that is exported from an application, so it's always the same, and copy/pasted into excel sheet over the previous day's table. The table has many locations and multiples of some of those. One of the columns is a sequence number so it'll show 1-10 if there were multiples of one location. On another summary page, I am using vlookup to search for a certain location in the table and kick out a number from another column in the table.

My problem is that if there are multiples for a location, the vlookup will only kick back the first number for the first value find in the table and not search the rest of the table. Is there a way to add vlookups together to have it search for the location first and then search by the sequence number before it kicks out a value? Or any other mix of functions to get this done like match or index?

not sure if i understand your question....but if you want to display more than one value for diffrent coloumns in the table use vlookup and match for the table