?formula

[Guest]

I have Two columns A & B on one sheet and two on another sheet C & D

If colum A = a number say 16 I would like it to find that number in Column C
and put the number parallell to it in D in coulmn B.

results would look like:
A B C D
16 70 {placed here} [finds] 16 70

I do not know if any of thid makes sense but it would save me time if i
could get thsi done. It would save looking up results in a table.
Thank you

 

[T. Valko]

Try this:

Assume:

Sheet1 A1 = 16

Sheet2 C1 = 16, D1 = 70

I assume you have a table that is bigger than just C11. Let's assume that
table is C110.

Enter this formula in Sheet1 B1:

=VLOOKUP(A1,Sheet2!C$1$10,2,0)

Biff