I'm not sure how you're nesting with COUNTIF(), but you can, if the name
is in the left-hand column of your lookup range, use VLOOKUP (else use
INDEX(MATCH()):

B1: =VLOOKUP($A1, Sheet2!A:F, 2, 0
C1: =VLOOKUP($A1, Sheet2!A:F, 3, 0)
....





In article ,
"easygoer714" wrote:

I am working on a workbook and i want to make a formula that will find
someone's name in a worksheet and use the values in the same row in set
columns to evaluate the formula. It will be nested with a countif function.
I need it to use the values with the specified name even if the record on
the other datasheet moves to a new row #.