View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RaeW RaeW is offline
external usenet poster
 
Posts: 1
Default VLOOKUP results is duplicating first value

Hello,
I read thru the posts but didn't seem to find my exact issue, so can someone
help me?
I'm using a partnumber in one sheet that is missing the supplier information
and doing a VLOOKUP to match the partnumber and retreive the supplier from
that sheet.
My results has the first supplier in it, but when I drag that down or try to
copy and paste it I get the same exact value for every part number instead of
the one that actually applies.
What am I doing wrong?