?formula

E

EOB

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

T. Valko

Try this:

Assume:

Sheet1 A1 = 16

Sheet2 C1 = 16, D1 = 70

I assume you have a table that is bigger than just C1:D1. Let's assume that
table is C1:D10.

Enter this formula in Sheet1 B1:

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

Biff
 
Top