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

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

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

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