View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cultgag[_6_] cultgag[_6_] is offline
external usenet poster
 
Posts: 1
Default 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