excel - If B2 in sheet 1 matches any cell on sheet 3, copy the next cell from sheet 3. (copying to sheet 1) -

excel - If B2 in sheet 1 matches any cell on sheet 3, copy the next cell from sheet 3. (copying to sheet 1) -

anyone give me excel formula this? give thanks you!

if b2 in sheet 1 matches cell column of sheet 3, re-create cell found on right of (column b).

copying cell in sheet 1.

thanks! (i hope isn't confusing.)

for illustration b2 "8 december". there list of dates on column of sheet 3. on column b of sheet 3 corresponding time. example, on right of 8 dec on sheet 3 8:30, want copied on cell i'm making formula on.

some folk utilize lookup function this, utilize match , index because gives more freedom more advanced formula (such checking if there match or not) , has less requirements (such info doesn't need sorted).

=index(sheet3!b:b, match(sheet1!b2, sheet3!a:a, 0))

if break downwards parts, match(sheet1!b2, sheet3!a:a, 0) returns row number first matching cell in column of sheet sheet3. index(sheet3!b:b, ...) returns value of cell in column b of sheet sheet3 @ specified row number.

if nil matched, you'll #na error value.

excel