LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup or index match function Dave Excel Worksheet Functions 1 January 29th 08 03:08 PM
Vlookup/Match Function PiB311 Excel Worksheet Functions 1 August 22nd 07 07:02 PM
vlookup/ match or other function?? Claudia Excel Worksheet Functions 3 May 16th 07 05:23 PM
MATCH function in a VLOOKUP trevor_tito Excel Worksheet Functions 10 October 4th 06 01:37 AM
Function Vlookup, Match or Index? Patrick Young Excel Worksheet Functions 7 October 4th 05 02:07 AM


All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"