Find Maching in the Excel

[Alan Tang]

Hello:

    I have create 2 Excel Sheet. Sheet "Existing" is for the old application list, the Sheet "Convert" Column A is the old application, Colume B is the new application.

Is it possible to write a formular to find the software name in A1 and find the macth in Sheet "Convert" in Colume B and disable in Existing Colume B.

E.G.
Sheet "Existing"
A                   
WinXIP 1.0
LZZ 1.0
PKXIP 1.0

Sheet "Convert"
A                               B
WinXIP 1.0               WinXIP 10.0
PKXIP 1.0                 PKXIP 10.0
LZZ 1.0                      WinXIP 10.0

Except result in Sheet "Existing" Colume B
WinXIP 10.0
WinXIP 10.0
PKXIP 10.0

Thansk a lot!
 

 

[Max]

Data is assumed in row1 down in both sheets

In sheet: Existing
Put in B1: =VLOOKUP(A1,Convert!A:B,2,0)
Copy B1 down as far as required
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
Hello:

I have create 2 Excel Sheet. Sheet "Existing" is for the old application list, the Sheet "Convert" Column A is the old application, Colume B is the new application.

Is it possible to write a formular to find the software name in A1 and find the macth in Sheet "Convert" in Colume B and disable in Existing Colume B.

E.G.
Sheet "Existing"
A
WinXIP 1.0
LZZ 1.0
PKXIP 1.0

Sheet "Convert"
A B
WinXIP 1.0 WinXIP 10.0
PKXIP 1.0 PKXIP 10.0
LZZ 1.0 WinXIP 10.0

Except result in Sheet "Existing" Colume B
WinXIP 10.0
WinXIP 10.0
PKXIP 10.0

Thansk a lot!

 

[Alan Tang]

Thanks a lot!

 

[Max]

You're welcome !