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
|