S
Steve
I have a sheet with downloaded data:
col c with Name & col f with ID data as below:
C F
Smith 123
Jones 456
I have another sheet with the same info, different cols.
H L
Smith 123
Jones 321
I created another sheet that just has the above data referenced from the 2
sheets:
A B C
D
sheet1!C1(smith) sheet1!F1(123) sheet2!H1(smith) sheet2!L1(123) OK
sheet1!C2(jones) sheet1!F2(456) sheet2!H2(jones) sheet2!L2 (321)
Alert
I then want to cross-reference as follows: being that the ID#'s ( col B &
col d) for smith in row 1 match, then I'll have an OK in the E col.. but if
the #'s don't match, like in the jones row ( col B & col D), then I'll have
an alert in the E col. I could do the last part, if(B1=D1,"ok","alert"), but
what formulas/functions do I need on sheet 3 to obtain the data from sheet 1
& 2 ? The data locations on sheets 1 & 2 are variable, so I tried doing a
Vlookup, but can't to get it to work.
I tried to have Vlookup return the name next to the ID, and if the same ID
from the other column didn't match it name, then the alert.
This probably doesn't make any sense, but hopefully.... Any help would be
greatly appreciated.
Thanks,
Steve
col c with Name & col f with ID data as below:
C F
Smith 123
Jones 456
I have another sheet with the same info, different cols.
H L
Smith 123
Jones 321
I created another sheet that just has the above data referenced from the 2
sheets:
A B C
D
sheet1!C1(smith) sheet1!F1(123) sheet2!H1(smith) sheet2!L1(123) OK
sheet1!C2(jones) sheet1!F2(456) sheet2!H2(jones) sheet2!L2 (321)
Alert
I then want to cross-reference as follows: being that the ID#'s ( col B &
col d) for smith in row 1 match, then I'll have an OK in the E col.. but if
the #'s don't match, like in the jones row ( col B & col D), then I'll have
an alert in the E col. I could do the last part, if(B1=D1,"ok","alert"), but
what formulas/functions do I need on sheet 3 to obtain the data from sheet 1
& 2 ? The data locations on sheets 1 & 2 are variable, so I tried doing a
Vlookup, but can't to get it to work.
I tried to have Vlookup return the name next to the ID, and if the same ID
from the other column didn't match it name, then the alert.
This probably doesn't make any sense, but hopefully.... Any help would be
greatly appreciated.
Thanks,
Steve