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: 3
Default Cross referencing

I am trying to pull the information from the cell at the intersection between
a particular row and column. The identifier for which row and column needs to
come from an input value. I have tried various incarnations of vlookup and
hlookup with match, but cannot get a result.

Example: Input Values would be 200 and FL310 to establish an answer of 177

FL300 FL310 FL320
100 180 178 176
200 179 177 175
300 175 174 172

Any help would be much 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
Cross referencing with VLookup ? Steve Excel Worksheet Functions 10 April 20th 07 09:08 PM
Cross-Referencing Across Worksheets Chris Hall Excel Worksheet Functions 0 April 5th 07 08:02 PM
Cross Referencing Saxman Excel Discussion (Misc queries) 0 October 26th 06 04:58 PM
Cross referencing sb1920alk Excel Worksheet Functions 1 October 4th 06 02:22 AM
cross referencing Phil Excel Worksheet Functions 6 August 2nd 05 06:07 PM


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