vlookup
if i have a list 1 2 3 4 5 6 1 and i want to use the vlookup function to return the second 1 value and all the data to the right of it whats the fromula ? (assuming i have data to the right) -- Zygan ------------------------------------------------------------------------ Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423 View this thread: http://www.excelforum.com/showthread...hreadid=550179 |
vlookup
From Excel Help on VLOOKUP():
"If there are two or more values in the first column of table_array that match the lookup_value, the first value found is used. If an exact match is not found, the error value #N/A is returned." Basically that says it's always going to pick up the values from the 1st matched value and never see the second duplicate value. Sorry. "Zygan" wrote: if i have a list 1 2 3 4 5 6 1 and i want to use the vlookup function to return the second 1 value and all the data to the right of it whats the fromula ? (assuming i have data to the right) -- Zygan ------------------------------------------------------------------------ Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423 View this thread: http://www.excelforum.com/showthread...hreadid=550179 |
All times are GMT +1. The time now is 05:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com