Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to lookup a value from a ramge of data. Eg Column C Row D? | Excel Worksheet Functions | |||
auto fill data into a cell from a lookup table | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Lookup Access data in Excel | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |