Prev Previous Post   Next Post Next
  #1   Report Post  
Tosca
 
Posts: n/a
Default Lookup data

Hello everyone

I have Excel 2003 and a grid of data. Columns A, C and E contain unique
data (one instance of each data value in each column and within the whole
grid) and the data in each of the columns is sorted alpha-numerically (A & B
relate to each other as do C & D and E & F). I need to be able to lookup a
particular value in the whole grid and return the contents of the cell
immediately to the right of the cell that matches the data. The match will
be exact. I had thought about using VLOOKUP but that can't be used to refer
to the whole grid of data (so far as I'm aware) - it would have to refer to
data contained in columns A & B or C & D or E & F. The data that is being
sought may be in any of these columns and this is out of my control.

I'm sure that this is simple - but it's beyond me! How can I perform this
lookup?

Thanks in anticipation.


 
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 lookup a value from a ramge of data. Eg Column C Row D? ST Excel Worksheet Functions 4 April 22nd 05 11:50 AM
auto fill data into a cell from a lookup table Tetradpoint Excel Discussion (Misc queries) 1 April 19th 05 04:46 PM
How can deleted data reappear in a refreshed pivot table in Excel excel_user123456 Excel Discussion (Misc queries) 3 February 23rd 05 08:34 PM
Lookup Access data in Excel Chris Kellock Excel Worksheet Functions 1 December 28th 04 01:51 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM


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