View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Belinda7237 Belinda7237 is offline
external usenet poster
 
Posts: 106
Default Vlookup or match function?

I can't quite get this to work, hoping someone can help:

I have two worksheets and if there is a match i want it to return a value:

sheet 1
A1 = package #
b1 = rework reason (this field is blank and is where i want the data
populated)

sheet 2
f1 = package number
g1 = rework reason

If there is a matching package number on sheet 2, then i want the rework
reason in column G to be placed in the rework reason in sheet 1 column B.

Any help is appreciated