Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Hi!
In Sheet1 H16 enter this formula: =IF(Sheet2!E5="","",VLOOKUP(Sheet2!E5,Sheet3!A1:B4 ,2,0)) Biff "Steve" wrote in message ... 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 |
#3
|
|||
|
|||
Thanks much,
It worked great. Steve "Biff" wrote: Hi! In Sheet1 H16 enter this formula: =IF(Sheet2!E5="","",VLOOKUP(Sheet2!E5,Sheet3!A1:B4 ,2,0)) Biff "Steve" wrote in message ... 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 |
#4
|
|||
|
|||
You're welcome! Thanks for the feedback.
Biff "Steve" wrote in message ... Thanks much, It worked great. Steve "Biff" wrote: Hi! In Sheet1 H16 enter this formula: =IF(Sheet2!E5="","",VLOOKUP(Sheet2!E5,Sheet3!A1:B4 ,2,0)) Biff "Steve" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Please Help - Trying to use one table to complete another | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
table | Excel Discussion (Misc queries) | |||
Pivot table : Excel cannot complete this task with available resou | Excel Worksheet Functions |