I am trying to get a formula between two worksheets. Basically, if any value
in column A on worksheet 1 matches a value in column A of worksheet 2,
provide me the value shown in column B in worksheet 2. Any suggestions?
--
Felicia

Here's 2 ways to look it up - vlookup or index/match

In Sheet2,

Place in B2:
=IF(ISNA(MATCH(A2,Sheet1!A:A,0)),"",VLOOKUP(A2,She et1!A:B,2,0))
Copy down as far as required

Alternatively, you could use in B2:
=IF(ISNA(MATCH(A2,Sheet1!A:A,0)),"",INDEX(Sheet1!B :B,MATCH(A2,Sheet1!A:A,0)))
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"2Fishie" wrote:
I am trying to get a formula between two worksheets. Basically, if any value
in column A on worksheet 1 matches a value in column A of worksheet 2,
provide me the value shown in column B in worksheet 2. Any suggestions?
--
Felicia

Try this:

=VLOOKUP(A1,Sheet2!A:B.2,0)

--
Biff
Microsoft Excel MVP


"2Fishie" wrote in message
...
I am trying to get a formula between two worksheets. Basically, if any
value
in column A on worksheet 1 matches a value in column A of worksheet 2,
provide me the value shown in column B in worksheet 2. Any suggestions?
--
Felicia