Thread: Find function
View Single Post
  #3   Report Post  
Jenniferpod Jenniferpod is offline
Junior Member
  
Posts: 8
Default
Quote:
Originally Posted by Spencer101 View Post
=IFERROR(VLOOKUP(A2,CHOOSE({1,2},SHEET2!B:B,SHEET2 !A:A),2,FALSE),"")

This should do what you need if you're using Excel 2007 or later.
It keeps saying I have a circular reference
Reply With QuoteReply With Quote