| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 70903 | 2006-07-20 06:50:00 | Multiple column lookup Ecel 2000 | tvg70 (2047) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 472263 | 2006-07-20 06:50:00 | I want to create a formula to use two cells to lookup two cells on another worksheet and return a result from the third column of that lookup range. | tvg70 (2047) | ||
| 472264 | 2006-07-20 10:22:00 | Hi, Vlookup and Hlookup can only use one criteria but using a combination of Index and Match allows you to use multiple criteria. See support.microsoft.com regards, Graham |
Parry (5696) | ||
| 472265 | 2006-07-21 06:06:00 | Thanks for your help, I used a get around solution in the end. I concatenated the two cells to one for the look up value and added a extra column to the data to look up which I concaatenated the two columns in for the lookup value. I works but a long way round to get a result, but less it worked. Once again thanks for your help the link was helpful to. Regards Terry |
tvg70 (2047) | ||
| 1 | |||||