Vlookup
Is there way to control the match result in the lookup formula. Basically, there could be five results that meet the match criteria. Is there a way I could control the number in which the lookup pull the informaiton -- MD2005 ------------------------------------------------------------------------ MD2005's Profile: http://www.excelforum.com/member.php...o&userid=32285 View this thread: http://www.excelforum.com/showthread...hreadid=520402 |
Vlookup
Some clarification on your page design, and the type of information contained
in your cells would help some. This link may assist you, http://www.contextures.com/xlFunctions02.html It shows how to use the (lookup formulas) and how to combine them with (if statements) if necessary. You may also need to limit the cell range of your lookup formula. "MD2005" wrote: Is there way to control the match result in the lookup formula. Basically, there could be five results that meet the match criteria. Is there a way I could control the number in which the lookup pull the informaiton |
Vlookup
The values in question are text. There could be five exact matches for the same Vlookup. While I acknowledge that all five answers /results are correct, I would like to tell the formula which result of the five I want pulled -- MD2005 ------------------------------------------------------------------------ MD2005's Profile: http://www.excelforum.com/member.php...o&userid=32285 View this thread: http://www.excelforum.com/showthread...hreadid=520402 |
All times are GMT +1. The time now is 11:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com