Linking of information... Help needed!!

[silverskye787]

Sheet1

Sheet2

i needs to enter the codes in sheet1 C2:C7

if sheet1 range from B2:B7 is equal to sheet2 range from C4:E4 then the staff name in sheet2 will display on sheet1 range from C2:C7

need some help here... thanks alot..

 

[galileogali]

See you the Excel Help for HLOOKUP function. This is a valid key for this question

GALILEOGALI

 

[silverskye787]

i look at the help but still unsure which is the one that fits my problems

 

[Stephan Hoenselaar]

Use Hlookup like this in sheet1 cell C2 :
"=HLOOKUP($B1,Sheet2!$4:$5,2,FALSE)" or
"=IF(ISERROR(HLOOKUP($B1,Sheet2!$4:$5,2,FALSE),"",HLOOKUP($B1,Sheet2!$4:$5,2,FALSE)" if you don't want to see the N/A if there is a staff member missing.