LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J BRAUD
 
Posts: n/a
Default Table array in VLOOKUP (EXcel 2003)

Hi

I use the VLOOKUP formula: =VLOOKUP(C21;PALIER;2) in which PALIER is a table
array and it works. I want now to have the "PALIER" changed by getting it
from another cell: =VLOOKUP(C21;C22;2) = i wrote "PALIER" in cell C22....
and that does not work anymore.

Is it a format issue , a table array issue or a Vlookup issue ?

Thanks.
jerome


 
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
How to schedule a pivot table in excel 2003? CY Excel Discussion (Misc queries) 3 March 27th 06 10:59 PM
Pivot Table report discarded in Excel 2003 - any fix available? Desperate Don Excel Discussion (Misc queries) 3 November 30th 05 07:10 PM
Linking table in Excel to word travis Links and Linking in Excel 1 November 19th 05 02:30 PM
Using single cell reference as table array argument in Vlookup CornNiblet Excel Worksheet Functions 3 September 22nd 05 09:15 AM
In Excel 2003 how do you get a table to update based on lookup cr. cliveshelton Excel Worksheet Functions 0 April 20th 05 04:24 PM


All times are GMT +1. The time now is 01:48 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"