Prev: Programming style with worksheet functions - discussion invited
Next: Need a type of lookup / find formula PLEASE
From: clevelandkid on 30 Mar 2010 12:13
I am looking to create a formula that will see if a value from column 1 sheet
1 is present in column 1 sheet 2, and if it is, return the value from column
2 sheet 2...

Can anyone help me with this?

Thanks in advance...
From: Gary''s Student on 30 Mar 2010 12:18
=VLOOKUP(Sheet1!A1,Sheet2!A1:B1000,2)

This gets A1 from Sheet1 and tries to find it in column A of Sheet2. If
found, the value in column B is returned.
--
Gary''s Student - gsnu201001


"clevelandkid" wrote:

> I am looking to create a formula that will see if a value from column 1 sheet
> 1 is present in column 1 sheet 2, and if it is, return the value from column
> 2 sheet 2...
>
> Can anyone help me with this?
>
> Thanks in advance...
From: trip_to_tokyo on 30 Mar 2010 12:24
EXCEL 2007

Please refer to my website:-

http://www.pierrefondes.com/

Item Number 57.

If you type in the number 1 in worksheet_1 cell A10 it will return ref 1 in
cell B10.

If you type in the number 2 in worksheet_1 cell A9 it will return ref 2 in
cell B9.

If you type in the number 3 in worksheet_1 cell A8 it will return ref 3 in
cell B8 and so on.

This appears to be what you want.

If you agree please hit Yes.

Thanks.







"clevelandkid" wrote:

> I am looking to create a formula that will see if a value from column 1 sheet
> 1 is present in column 1 sheet 2, and if it is, return the value from column
> 2 sheet 2...
>
> Can anyone help me with this?
>
> Thanks in advance...
 | 
Pages: 1
Prev: Programming style with worksheet functions - discussion invited
Next: Need a type of lookup / find formula PLEASE