Excel Formula Help!!!

[pmaths]

Hi,

I'm looking for some assistance please.

I have two excel worksheets and I want a formula that will do the following:

Within cell B1 in worksheet 1 look at the value in cell A1 in worksheet 1 and check for a matching value in column A in worksheet 2, and where there is a match enter the value from the corresponding cell in column B.

i.e. if cell A1 in WS1 = 1 then check column A in WS2 for the value of 1, when it finds the matching value say in A5 then I want B1 in WS1 to = the value set in E5 in WS2.

Any assistance would be gratefully received.

 

[GlennUK]

Have you tried VLOOKUP?

faq68-4743

Next time you post a question will you please type a more meaningful title, and don't put multiple "!!!" ... it smacks of someone screaming "URGENT", which is very offputting for most people on here ( and usually ends with with everyone ignoring the post ).

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Spooku777]

Try this formula in B1 on Sheet1

=IF(A1=Sheet2!A1,A1,"")

or

=IF(A1=Sheet2!A1,"Match","No Match")


You can then copy and paste the formula down column B and it will keep the relative references
eg. copying the formula to B4 will result in =IF(A4=Sheet2!A4,A4,"")

 

[AnotherHiggins]

Spooku777 - that only checks one cell from Sheet2. The OP asked about looking for a match anywhere in Column A on Sheet2, and if there is a match pull in the related value from Column B on Sheet2.

VLookup does exactly that.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.