Formula getting confused

P

Patcheen

New member
Joined
Apr 27, 2018
Messages
4
Reaction score
0
Points
0
Excel Version(s)
2010
I have this formula

=IF('Raw data'!$C$2:C$10=A2,'Raw data'!$D$2:$D$10)) it works fine

but if i change it to

=IF('Raw data'!$C$552:$C$571=A2,'Raw data'!$X$552:$X$571) i get #value

TIA
 
So what have you checked? The obvious thing is the nature of the entries in those ranges and whether or not there are real matches. Beyond that, without seeing the workbook, it's hard to say.
 
Hope this helps
 

Attachments

  • book 1.xlsx
    21.4 KB · Views: 8
I think you are trying to lookup a match, correct?

Try:

=VLOOKUP(A2,'Sheet 1'!$C$15:$D$20,2,FALSE)

copied down.
 
You must log in or register to reply here.
Back
Top