Ref from table - complete

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top