Match data and return data from another cell

[Dawn Clark]

My formula: =IF(MATCH('Sheet 1'!A2,'Sheet 2'!R$2:R$40000,0),'Sheet 2'!S$2:S$40000)

Does my formula mean; If cell A2 (sheet 1) matches contents in a cell in column R (sheet 2) exactly, it will return value from matching cell (same row) in column S (sheet 2)?

[jeffreybrown]

Not really, but is that what you are trying to do?

If so, I think you would need...

=INDEX('Sheet 2'!S$2:S$40000,MATCH('Sheet 1'!A2,'Sheet 2'!R$2:R$40000,0))

or

=LOOKUP('Sheet 1'!A2,'Sheet 2'!R$2:R$40000,'Sheet 2'!S$2:S$40000)

or

=VLOOKUP('Sheet 1'!A2,'Sheet 2'!$R$2:$S$4000,2,0)

[Dawn Clark]

You are a lifesaver! First formula worked!! Thanks so much!