LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default VLOOKUP - Possibility of using a negative Col_index_num?

VLOOKUP - Possibility of using a negative Col_index_num?

I have this workbook with two worksheets, Sheet1 and Sheet 2. On
Sheet1, the user would enter dates on I11:J16. The corresponding names
for the dates are located on A11:B16 (merged cell)

On Sheet2, column A is a list of dates. I'd like for the formula to
look at dates on Sheet 2, column A. If any of the dates on Sheet2 -
Column A match on Sheet1 I11:J16, on the matching row of Sheet1, take
the information from A11:B16 (merged cell) and place it into Sheet2,
Column B.

For example, on Sheet 1, there is a value of Feb 2 on I11. If Feb 2 is
found in any row of Sheet 2 - Column A (say A6), I'd like to take the
corresponding text on Sheet1 - A11, and place it in Sheet 2, B6.

What is the best way to solve this issue?

 
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 with different col_index_num ArcticWolf Excel Worksheet Functions 7 August 17th 09 11:46 AM
VLOOKUP and using a Name in the col_index_num Beans Excel Worksheet Functions 2 July 24th 09 09:39 PM
vlookup - Col_index_num xyz Excel Discussion (Misc queries) 10 December 6th 07 04:18 PM
possibility of pasting numbers with negative sign placed after Alain Excel Discussion (Misc queries) 2 August 10th 06 07:48 PM
Vlookup Col_index_num Mort Australia Excel Discussion (Misc queries) 5 March 24th 06 10:37 AM


All times are GMT +1. The time now is 03:46 AM.

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"