love2myfriends
New Member
- Joined
- Aug 11, 2009
- Messages
- 1
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?
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?