LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Steve
 
Posts: n/a
Default Ref from table - complete

Sorry, it was sent before I was finished.

Sheet 3 such as:
a b
1 125 1
2 236 2
3 451 3
4 668 4

If I enter one of the numbers in the 'a' column e.g., 451 in sheet 2 cell
e5, I need to have the corresponding # in the b column (3) show up in sheet 1
cell h16.

What formula would I use in sheet 1 h16 to get those results ?

Thanks,

Steve
 
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
updating pivot table to include additional rows Ellen Excel Discussion (Misc queries) 8 July 15th 08 01:33 PM
Please Help - Trying to use one table to complete another Methodman1 Excel Discussion (Misc queries) 4 June 13th 05 04:01 PM
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
table dow Excel Discussion (Misc queries) 0 January 12th 05 02:25 PM
Pivot table : Excel cannot complete this task with available resou Julie Excel Worksheet Functions 0 November 5th 04 04:09 AM


All times are GMT +1. The time now is 01:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"