Hey guyz!!.. i would like to get data from Sheet1 column A then check if it exist in sheet3 at column A if it exists i would like to display the contents of column G of the matching row in sheet3.

If you can help with that realtime i would deeply apreciate it.

Or better if there is a function in Excel that can look for data if it exists in a different sheet please holla at me thanx

LION OF JUDDAH!

__________________
LION OF JUDDAH!

chiefouko,

There are several snippets relating to this at http://www.vba-programmer.com (in Excel Code Snippets area).

Selecting cells, determining last cells with data, and selecting different sheets.

CarlR

Use VLOOKUP, this is a function key.

In SHEET1 cell B1, type =VLOOKUP(A1,SHEET3!A:G,7,FALSE) or follow the function key.

=VLOOKUP(A1, means look for the value of SHEET1 cell A1

SHEET3!A:G,7, means within SHEET3 from col A to G take the value on the 7th col (G).

FALSE means return the value only if SHEET1 cell A1 is exactly the same as SHEET3 cell A1.

Goodluck

Hi,

Well VLOOKUP is good option to use. Its fast and short. If u still face problems, u can declare 2 excel sheet objects and compare one by one within two loops. When ever a match in found, get the Value of Colum G of sheet3 object.

I guess u know the Syntax well. Please ask if u never used the syntax.

B. Anant