IF formula question

  • Thread starter Thread starter KingCreole
  • Start date Start date
K

KingCreole

Hi all, i have a spreadsheet formatted as below

Sheet1

Name Pin Time
Fred 3325 3.25
Dave 3326 5.42
Chris 3327 5.42

Sheet 2

Name Pin Time
Bob 2322
Dave 3325
Fred 3326
Chris 3327

What i want is a formula in the time column of sheet 2 that will look
in sheet 2 first and say if that pin number matches a pin number in
sheet 1 then in the Time Column of sheet 2 the Time Value of sheet 1
should be displayed

The names in sheet 2 and sheet 1 will not be in the same row but will
be in the same column so the formula will need to look at the whole
column. This 1's got me completely stumped so i would appreciate any
guidance

Thanks in advance
 
=INDEX(Sheet1!$C:$C,MATCH(B2,Sheet1!$B:$B,0))

I notice Fred & Dave has different ids :-)
 
Back
Top