Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP but return a different row
Hi, I am trying to match a part number with a separate .csv file to update inventory. My dilemma is I am using VLookup to accomplish this but there has been some changes to the .csv file format and now the inventory on hand is on a separate row with the part number. Now if my understanding is correct, since the vlookup function can only return values from the same row it will not work with what I need... Any help is greatly appreciated! TIA~ -- cultgag ------------------------------------------------------------------------ cultgag's Profile: http://www.excelforum.com/member.php...o&userid=22677 View this thread: http://www.excelforum.com/showthread...hreadid=517385 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP but return a different row
one way would be to seperate the cell using
Data=text to columns select comma , if the files join together all the time when they are updated, you could always record a macro that would do this routine then you would assign it to a button! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP but return a different row
Hi,
I'd Use MATCH (similar parameters to vlookup) to return the row & either INDIRECT or INDEX to return the values of the cell(s) in the row below by incrementing the result of the MATCH by 1. Regards, Chris. -- Chris Marlow MCSD.NET, Microsoft Office XP Master "cultgag" wrote: Hi, I am trying to match a part number with a separate .csv file to update inventory. My dilemma is I am using VLookup to accomplish this but there has been some changes to the .csv file format and now the inventory on hand is on a separate row with the part number. Now if my understanding is correct, since the vlookup function can only return values from the same row it will not work with what I need... Any help is greatly appreciated! TIA~ -- cultgag ------------------------------------------------------------------------ cultgag's Profile: http://www.excelforum.com/member.php...o&userid=22677 View this thread: http://www.excelforum.com/showthread...hreadid=517385 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP but return a different row
I would be more inclined to go with index over indirect for purely
performance reasons. Indirect is volatile and will slow thing down... Here is a good reference... http://www.decisionmodels.com/optspeede.htm -- HTH... Jim Thomlinson "Chris Marlow" wrote: Hi, I'd Use MATCH (similar parameters to vlookup) to return the row & either INDIRECT or INDEX to return the values of the cell(s) in the row below by incrementing the result of the MATCH by 1. Regards, Chris. -- Chris Marlow MCSD.NET, Microsoft Office XP Master "cultgag" wrote: Hi, I am trying to match a part number with a separate .csv file to update inventory. My dilemma is I am using VLookup to accomplish this but there has been some changes to the .csv file format and now the inventory on hand is on a separate row with the part number. Now if my understanding is correct, since the vlookup function can only return values from the same row it will not work with what I need... Any help is greatly appreciated! TIA~ -- cultgag ------------------------------------------------------------------------ cultgag's Profile: http://www.excelforum.com/member.php...o&userid=22677 View this thread: http://www.excelforum.com/showthread...hreadid=517385 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP but return a different row
the index with the match function works great! Thanks for the replies! :) -- cultgag ------------------------------------------------------------------------ cultgag's Profile: http://www.excelforum.com/member.php...o&userid=22677 View this thread: http://www.excelforum.com/showthread...hreadid=517385 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Vlookup then interpolate,return corresponding value, if not, return other value | Excel Worksheet Functions | |||
vlookup w/ more than one return value | Excel Discussion (Misc queries) | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup that does not return #N/A | Excel Worksheet Functions | |||
VBA Syntax for VLOOKUP to return array of return values | Excel Programming |